{"provider_name":"Hatena Blog","type":"rich","height":"190","author_name":"sironekotoro","author_url":"https://blog.hatena.ne.jp/sironekotoro/","published":"2014-08-02 16:22:51","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsironekotoro.hateblo.jp%2Fentry%2F2014%2F08%2F02%2F162251\" title=\"Excel VBA\u30b9\u30bf\u30f3\u30c0\u30fc\u30c9 \u516c\u5f0f\u30c6\u30ad\u30b9\u30c8 \uff11\uff10\u7ae0 \u30e1\u30cb\u30e5\u30fc\u306e\u64cd\u4f5c - sironekotoro\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","image_url":null,"categories":[],"url":"https://sironekotoro.hateblo.jp/entry/2014/08/02/162251","provider_url":"https://hatena.blog","version":"1.0","blog_title":"sironekotoro\u306e\u65e5\u8a18","blog_url":"https://sironekotoro.hateblo.jp/","title":"Excel VBA\u30b9\u30bf\u30f3\u30c0\u30fc\u30c9 \u516c\u5f0f\u30c6\u30ad\u30b9\u30c8 \uff11\uff10\u7ae0 \u30e1\u30cb\u30e5\u30fc\u306e\u64cd\u4f5c","description":"10-1 \u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30e1\u30cb\u30e5\u30fc\u3068\u306f \u30bb\u30eb\u3084\u5217\u898b\u51fa\u3057\u7b49\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u51fa\u3066\u304f\u308b\u30e1\u30cb\u30e5\u30fc VBA\u3067\u6271\u3046\u3068\u304d\u306fCommandBar\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u8868\u3055\u308c\u308b\u3002 CommandBar\u306e\u96c6\u5408\u304cCommandBars\u30b3\u30ec\u30af\u30b7\u30e7\u30f3 \u300c\u5207\u308a\u53d6\u308a\u300d\u300c\u30b3\u30d4\u30fc\u300d\u306a\u3069\u306e\u30b3\u30de\u30f3\u30c9\u306fCommandBarControl\u30aa\u30d6\u30b8\u30a7\u30af\u30c8 Controls\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u64cd\u4f5c\u3059\u308b `\u30bb\u30eb\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u305f\u3068\u304d\u306b\u9078\u629e\u53ef\u80fd\u306a\u30b3\u30de\u30f3\u30c9\u6570\u304c\u8868\u793a\u3055\u308c\u308b MsgBox CommandBars(\"Cell\").Controls.Count '\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30e1\u30cb\u30e5\u30fc\u306e\uff14\u756a\u76ee\u300c\u5f62\u5f0f\u3092\u9078\u629e\u3057\u3066\u8cbc\u4ed8\u3051\u300d\u3068\u3044\u3046\u6587\u5b57\u5217\u304c\u8868\u793a\u3055\u308c\u308b MsgBox CommandBa\u2026"}