{"width":"100%","blog_title":"\u30b7\u30b9\u30c6\u30e0\u958b\u767a\u30b9\u30af\u30fc\u30eb\u8b1b\u5ea7","height":"190","version":"1.0","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsystem.hatenablog.jp%2Fentry%2F2016%2F04%2F10%2F023954\" title=\"VBA\u30d5\u30a9\u30fc\u30e0\u3067\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306e\u3044\u305a\u308c\u304b\u306e\u30c1\u30a7\u30c3\u30af\u6709\u3092\u53d6\u5f97\u306b\u95a2\u3059\u308b\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3 - \u30b7\u30b9\u30c6\u30e0\u958b\u767a\u30b9\u30af\u30fc\u30eb\u8b1b\u5ea7\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","author_name":"super-systemer","description":"VBA\u306b\u3064\u3044\u3066\u306e\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3067\u3059\u3002Excel\u9867\u5ba2\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u5236\u4f5c\u6642\u306b\u30d5\u30a9\u30fc\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u5185\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306e\u3069\u308c\u304b\u304c\u30c1\u30a7\u30c3\u30af\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u5834\u5408\u306b\u3064\u3044\u3066\u306e\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3067\u3059\u3002\u25c6\u8a18\u8ff0\u4f8b------------------------------chkFlg = FalseFor i = 1 To 4 If Me.Controls(CheckBox & i).Value = True Then chkMSG = chkMSG & Me.Controls(CheckBox & i).Caption & vbCrLf chkFlg = True End IfNext i----------\u2026","categories":["VBA","\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9","\u53d6\u5f97","Excel"],"image_url":null,"title":"VBA\u30d5\u30a9\u30fc\u30e0\u3067\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306e\u3044\u305a\u308c\u304b\u306e\u30c1\u30a7\u30c3\u30af\u6709\u3092\u53d6\u5f97\u306b\u95a2\u3059\u308b\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3","blog_url":"https://system.hatenablog.jp/","author_url":"https://blog.hatena.ne.jp/super-systemer/","url":"https://system.hatenablog.jp/entry/2016/04/10/023954","type":"rich","published":"2016-04-10 02:39:54"}