{"id":3316,"date":"2023-10-31T18:23:37","date_gmt":"2023-10-31T18:23:37","guid":{"rendered":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/"},"modified":"2023-12-07T04:48:57","modified_gmt":"2023-12-07T04:48:57","slug":"vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/","title":{"rendered":"Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?"},"content":{"rendered":"<div class=\"excel-\" id=\"excel-2557774584\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>\u79c1\u304c VBA \u306b\u3064\u3044\u3066\u6700\u521d\u306b\u5b66\u3093\u3060\u306e\u306f\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9 (\u300cmsgbox \u95a2\u6570\u300d) \u306e\u4f7f\u3044\u65b9\u3067\u3057\u305f\u3002\u3053\u308c\u306f\u3001\u7279\u5b9a\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8868\u793a\u3059\u308b Excel \u30a6\u30a3\u30f3\u30c9\u30a6\u4e0a\u306e\u5358\u7d14\u306a\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7 \u30dc\u30c3\u30af\u30b9\u306e\u3088\u3046\u306a\u3082\u306e\u3067\u3059\u3002\u3088\u304f\u8003\u3048\u3066\u307f\u308b\u30682\u901a\u308a\u306e\u4f7f\u3044\u65b9\u304c\u3067\u304d\u307e\u3059\u3002<\/p><ul><li><strong>\u30e6\u30fc\u30b6\u30fc\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u914d\u4fe1\u3057\u307e\u3059\u3002<\/strong><\/li><li><strong>\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u7c21\u5358\u306a\u5fdc\u7b54\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/strong><\/li><\/ul><p>\u307b\u3068\u3093\u3069\u306e VBA \u30d7\u30ed\u30b0\u30e9\u30de\u30fc\u306f\u3001\u30de\u30af\u30ed \u30b3\u30fc\u30c9\u3092\u3088\u308a\u5bfe\u8a71\u7684\u306b\u3059\u308b\u305f\u3081\u306b\u3053\u308c\u3092\u30de\u30af\u30ed \u30b3\u30fc\u30c9\u5185\u3067\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3092\u77e5\u3089\u306a\u304b\u3063\u305f\u3068\u3057\u3066\u3082\u3001\u3053\u306e\u8a18\u4e8b\u3092\u8aad\u3093\u3060\u5f8c\u306f\u304d\u3063\u3068\u6c17\u306b\u5165\u308b\u306f\u305a\u3067\u3059\u3002<\/p><p><strong><span style=\"background-color: #ffff00;\">\u5c02\u9580\u5bb6\u306e\u30d2\u30f3\u30c8:<\/span><\/strong> VBA \u306e\u521d\u5fc3\u8005\u306e\u5834\u5408\u306f\u3001VBA \u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u5b66\u3076\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/p><p>\u305d\u3053\u3067\u4eca\u56de\u306f\u3001Excel \u3067\u306e\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306e\u4f7f\u3044\u65b9\u306e\u8a73\u7d30\u3068\u5b9f\u969b\u306e\u4f8b\u3092\u3044\u304f\u3064\u304b\u7d39\u4ecb\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p><p> \u2026\u59cb\u3081\u307e\u3057\u3087\u3046\u3002<\/p><h2>\u69cb\u6587<\/h2><p>=MSGBOX(\u30d7\u30ed\u30f3\u30d7\u30c8, [\u30dc\u30bf\u30f3], [\u30bf\u30a4\u30c8\u30eb], [\u30d8\u30eb\u30d7\u30d5\u30a1\u30a4\u30eb, \u30b3\u30f3\u30c6\u30ad\u30b9\u30c8]) <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\" sizes=\"auto, \" srcset=\"\" alt=\"msgbox vba \u95a2\u6570\u306e\u69cb\u6587\" width=\"317\" height=\"250\" data-attachment-id=\"14803\"><\/p><ul><li>\u30d7\u30ed\u30f3\u30d7\u30c8 \u30e1\u30c3\u30bb\u30fc\u30b8\u3068\u3057\u3066\u8868\u793a\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u6587\u5b57\u5217\u5f0f\u3002\u6700\u5927\u6587\u5b57\u9577\u306f 1024 \u6587\u5b57\u3067\u3001\u6587\u5b57\u5e45\u306b\u3088\u3063\u3066\u7570\u306a\u308a\u307e\u3059\u3002<\/li><li> [\u30dc\u30bf\u30f3] \u3053\u306e\u5f15\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u30dc\u30bf\u30f3\u3001\u30a2\u30a4\u30b3\u30f3 \u30b9\u30bf\u30a4\u30eb\u3001\u30dc\u30bf\u30f3 ID\u3001\u304a\u3088\u3073\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9 \u30e2\u30c0\u30ea\u30c6\u30a3\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/li><li> [title] \u3053\u306e\u5f15\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306e\u30bf\u30a4\u30c8\u30eb \u30c6\u30ad\u30b9\u30c8\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/li><li> [helpfile] \u3053\u306e\u5f15\u6570\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306e\u30d8\u30eb\u30d7 \u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u306f\u3001\u30d8\u30eb\u30d7 \u30dc\u30bf\u30f3\u3092\u4f7f\u7528\u3057\u3066\u3053\u306e\u30d8\u30eb\u30d7 \u30d5\u30a1\u30a4\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3059\u3002\u30d8\u30eb\u30d7 \u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u3001\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u756a\u53f7\u306e\u6307\u5b9a\u304c\u5fc5\u9808\u3067\u3059\u3002<\/li><li> [context] \u30d8\u30eb\u30d7 \u30e1\u30cb\u30e5\u30fc\u304b\u3089\u30d8\u30eb\u30d7 \u30c8\u30d4\u30c3\u30af\u3092\u5272\u308a\u5f53\u3066\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u6570\u5024\u5f0f\u3002<\/li><\/ul><p><strong>\u6ce8:<\/strong>\u4e0a\u8a18\u306e\u30ea\u30b9\u30c8\u3067\u3001\u89d2\u304b\u3063\u3053\u5185\u306e\u5f15\u6570\u306f\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u3059\u3002\u7701\u7565\u3057\u3066\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p><h2>\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u3092\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3057\u3001\u3055\u307e\u3056\u307e\u306a\u30dc\u30bf\u30f3\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5<\/h2><p>\u5229\u7528\u53ef\u80fd\u306a\u3059\u3079\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u3001VBA \u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u3092\u7c21\u5358\u306b\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002 <\/p><h3 style=\"font-size: 22px; margin-bottom: 20px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #1. vbOK\u306e\u307f<\/h3><p>\u3053\u308c\u306b\u3088\u308a\u3001\u30b7\u30f3\u30d7\u30eb\u306a [OK] \u30dc\u30bf\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u306f\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8aad\u3093\u3060\u5f8c\u306b\u30af\u30ea\u30c3\u30af\u3057\u3066\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u9589\u3058\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3055\u3089\u306b\u3001\u300cOK\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u3068\u304d\u306b\u5b9f\u884c\u3059\u308b\u30de\u30af\u30ed\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbokonly.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"142\" height=\"143\" data-attachment-id=\"14806\"><\/p><p> OKOnly() \u306e\u4e0b\u3067<\/p><p>MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := \u201c\u3053\u308c\u306f MsgBox \u3067\u3059\u201d, _<\/p><p>\u30dc\u30bf\u30f3:=vbOKOnly\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"font-size: 22px; margin-bottom: 20px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #2. vbOK\u30ad\u30e3\u30f3\u30bb\u30eb<\/h3><p>\u3053\u306e\u5b9a\u6570\u306b\u3088\u308a\u3001[OK] \u30dc\u30bf\u30f3\u3068 [\u30ad\u30e3\u30f3\u30bb\u30eb] \u30dc\u30bf\u30f3\u304c\u63d0\u4f9b\u3055\u308c\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u306b\u306f\u3001OK \u3092\u62bc\u3057\u3066\u7d9a\u884c\u3059\u308b\u304b\u3001\u30ad\u30e3\u30f3\u30bb\u30eb\u3057\u3066\u7d42\u4e86\u3059\u308b\u304b\u306e 2 \u3064\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbokcancel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"237\" height=\"143\" data-attachment-id=\"14808\"><\/p><p> OKCancel() \u306e\u4e0b\u3067<\/p><p>MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8:= \u00bb\u5927\u4e08\u592b\u3067\u3059\u304b? \u00bb\u3001_<\/p><p>\u30dc\u30bf\u30f3:=vbOK\u30ad\u30e3\u30f3\u30bb\u30eb\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #3. vb\u4e2d\u6b62\u518d\u8a66\u884c\u7121\u8996<\/h3><p>\u3053\u308c\u306b\u3088\u308a\u3001\u300cAbout\u300d\u3001\u300cRetry\u300d\u3001\u300cSkip\u300d\u306e 3 \u3064\u306e\u30dc\u30bf\u30f3\u3092\u8868\u793a\u3067\u304d\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u306f\u64cd\u4f5c\u3092\u4e2d\u6b62\u3057\u305f\u308a\u3001\u518d\u8a66\u884c\u3057\u305f\u308a\u3001\u7121\u8996\u3057\u305f\u308a\u3067\u304d\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbabortretryignore.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"335\" height=\"143\" data-attachment-id=\"14810\"><\/p><p> OKCancel() \u306e\u4e0b\u3067<\/p><p>MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8:= \u00bb\u5927\u4e08\u592b\u3067\u3059\u304b? \u00bb\u3001_<\/p><p>\u30dc\u30bf\u30f3:=vbOK\u30ad\u30e3\u30f3\u30bb\u30eb\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"font-size: 22px; margin-bottom: 20px !important; margin-top: 0px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #4. vb\u306f\u3044\u3044\u3044\u3048\u30ad\u30e3\u30f3\u30bb\u30eb<\/h3><p>\u3053\u306e\u5b9a\u6570\u306b\u306f\u3001\u306f\u3044\u3001\u3044\u3044\u3048\u3001\u30ad\u30e3\u30f3\u30bb\u30eb\u306e 3 \u3064\u306e\u30dc\u30bf\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u306f\u3001\u300c\u306f\u3044\u300d\u3092\u9078\u629e\u3057\u3066\u53d7\u3051\u5165\u308c\u3066\u7d9a\u884c\u3059\u308b\u304b\u3001\u300c\u3044\u3044\u3048\u300d\u3092\u9078\u629e\u3057\u3066\u62d2\u5426\u3059\u308b\u304b\u3001\u30ad\u30e3\u30f3\u30bb\u30eb\u3057\u3066\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u3092\u9589\u3058\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbyesnocancel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"335\" height=\"143\" data-attachment-id=\"14812\"><\/p><p> YesNoCancel() \u306e\u4e0b\u3067<\/p><p>MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := &#8220;\u30dc\u30bf\u30f3\u304c 3 \u3064\u3042\u308a\u307e\u3059&#8221;, _<\/p><p>\u30dc\u30bf\u30f3:=vbYesNoCancel\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #5. vb\u306f\u3044\u3044\u3044\u3048<\/h3><p>\u3053\u306e\u5b9a\u6570\u306b\u306f\u3001\u300c\u306f\u3044\u300d\u3068\u300c\u3044\u3044\u3048\u300d\u306e 2 \u3064\u306e\u30dc\u30bf\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u306f\u3001\u300c\u306f\u3044\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u53d7\u3051\u5165\u308c\u3066\u7d9a\u884c\u3059\u308b\u304b\u3001\u300c\u3044\u3044\u3048\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u62d2\u5426\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbyesno.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"237\" height=\"143\" data-attachment-id=\"14816\"><\/p><p> YesNo() \u306e\u4e0b\u3067<\/p><p>MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := &#8220;\u30dc\u30bf\u30f3\u304c 2 \u3064\u3042\u308a\u307e\u3059&#8221;, _<\/p><p>\u30dc\u30bf\u30f3:=vb\u306f\u3044\u3044\u3044\u3048\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #6. vb\u518d\u8a66\u884c\u30ad\u30e3\u30f3\u30bb\u30eb<\/h3><p>\u518d\u8a66\u884c\u3068\u30ad\u30e3\u30f3\u30bb\u30eb\u306e 2 \u3064\u306e\u30dc\u30bf\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u308c\u3092\u4f7f\u7528\u3057\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u64cd\u4f5c\u3092\u518d\u8a66\u884c\u3059\u308b\u304b\u3001\u64cd\u4f5c\u3092\u30ad\u30e3\u30f3\u30bb\u30eb\u3059\u308b\u304b\u3092\u8981\u6c42\u3067\u304d\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbretrycancel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"237\" height=\"143\" data-attachment-id=\"14819\"><\/p><p> Sub RetryCancel()MsgBox Prompt:=\u201d\u3082\u3046\u4e00\u5ea6\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\u201d, _Buttons:=vbRetryCancel, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> \uff037\u3002 vb\u30ec\u30d3\u30e5\u30fc<\/h3><p>\u3053\u306e\u5b9a\u6570\u306f\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306b\u30a2\u30a4\u30b3\u30f3\u3092\u8868\u793a\u3057\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u91cd\u8981\u3067\u3042\u308b\u3053\u3068\u3092\u793a\u3057\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbcritical.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"175\" height=\"160\" data-attachment-id=\"14822\"><\/p><p>\u30b5\u30d6\u30af\u30ea\u30c6\u30a3\u30ab\u30eb()<\/p><p> MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := \u201c\u3053\u308c\u306f\u91cd\u8981\u3067\u3059\u201d, _<\/p><p>\u30dc\u30bf\u30f3:=vbCritical\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #8. vb\u8cea\u554f<\/h3><p>\u3053\u306e\u5b9a\u6570\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u8cea\u554f\u3059\u308b\u3068\u304d\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbquestion.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"195\" height=\"160\" data-attachment-id=\"14825\"><\/p><p>\u30b5\u30d6\u8cea\u554f()<\/p><p> MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := \u00bb\u4eca\u4f55\u3092\u3059\u3079\u304d\u3067\u3059\u304b? \u00bb\u3001_<\/p><p>\u30dc\u30bf\u30f3:=vb\u8cea\u554f\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #9. vb\u611f\u5606\u7b26<\/h3><p>\u3053\u306e\u5b9a\u6570\u306f\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u3068\u3068\u3082\u306b\u611f\u5606\u7b26\u30a2\u30a4\u30b3\u30f3\u3092\u8868\u793a\u3057\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbexclamation.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"195\" height=\"160\" data-attachment-id=\"14828\"><\/p><p> UnderExclamation()<\/p><p> MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := \u00bb\u4eca\u4f55\u3092\u3059\u3079\u304d\u3067\u3059\u304b? \u00bb\u3001_<\/p><p>\u30dc\u30bf\u30f3:=vb\u611f\u5606\u7b26\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> \uff03\u5341\u3002 vb\u60c5\u5831<\/h3><p>\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u60c5\u5831\u3067\u3042\u308b\u3053\u3068\u3092\u793a\u3059\u30a2\u30a4\u30b3\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbinformation.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"195\" height=\"160\" data-attachment-id=\"14829\"><\/p><p> Sub Information()MsgBox Prompt:=\u201d\u3053\u308c\u304b\u3089\u4f55\u3092\u3057\u307e\u3059\u304b?\u201d, _Buttons:=vbInformation, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #11. vb\u30c7\u30d5\u30a9\u30eb\u30c8\u30dc\u30bf\u30f31<\/h3><p>\u3053\u306e\u5b9a\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306e\u6700\u521d\u306e\u30dc\u30bf\u30f3\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30dc\u30bf\u30f3\u3068\u3057\u3066\u6307\u5b9a\u3057\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbdefaultbutton1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"143\" data-attachment-id=\"14833\"><\/p><p> Sub DefaultButton1()MsgBox Prompt:=\u201dButton1 \u304c\u5f37\u8abf\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u304b?\u201d, _Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton1, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #12. vb\u30c7\u30d5\u30a9\u30eb\u30c8\u30dc\u30bf\u30f32<\/h3><p>\u3053\u306e\u5b9a\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306e 2 \u756a\u76ee\u306e\u30dc\u30bf\u30f3\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30dc\u30bf\u30f3\u3068\u3057\u3066\u6307\u5b9a\u3057\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/msgbox-vba-avec-vbdefaultbutton2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"143\" data-attachment-id=\"14834\"><\/p><p> Sub DefaultButton2()MsgBox Prompt:=\u201dButton2 \u304c\u5f37\u8abf\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u304b?\u201d, _Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton2, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #13. vb\u30c7\u30d5\u30a9\u30eb\u30c8\u30dc\u30bf\u30f33<\/h3><p>\u3053\u306e\u5b9a\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001msgbox \u306e 3 \u756a\u76ee\u306e\u30dc\u30bf\u30f3\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30dc\u30bf\u30f3\u3068\u3057\u3066\u6307\u5b9a\u3057\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/msgbox-vba-avec-vbdefaultbutton3.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"143\" data-attachment-id=\"14835\"><\/p><p> Sub DefaultButton3()MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8:=\u201dButton3 \u304c\u5f37\u8abf\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u304b?\u201d, _Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton3, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #14. vb\u30c7\u30d5\u30a9\u30eb\u30c8\u30dc\u30bf\u30f34<\/h3><p>\u3053\u306e\u5b9a\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001msgbox \u306e 4 \u756a\u76ee\u306e\u30dc\u30bf\u30f3\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30dc\u30bf\u30f3\u3068\u3057\u3066\u6307\u5b9a\u3057\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbdefaultbutton4.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"143\" data-attachment-id=\"14836\"><\/p><p> Sub DefaultButton4()MsgBox Prompt:=\u201dButton4 \u304c\u5f37\u8abf\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u304b?\u201d, _Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton4, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #15. vbApplicationModal<\/h3><p>\u3053\u306e\u5b9a\u6570\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3 (Excel) \u3092\u4e00\u6642\u505c\u6b62\u3057\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3059\u308b\u306b\u306f\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u306b\u8fd4\u4fe1\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p> OKOnly() \u306e\u4e0b\u3067<\/p><p>MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := \u201c\u3053\u308c\u306f MsgBox \u3067\u3059\u201d, _<\/p><p>\u30dc\u30bf\u30f3:=vbOKOnly\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = &#8220;\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9&#8221;, _<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #16. vb\u30b7\u30b9\u30c6\u30e0\u30e2\u30fc\u30c0\u30eb<\/h3><p>\u3053\u306e\u5b9a\u6570\u306f\u30aa\u30da\u30ec\u30fc\u30c6\u30a3\u30f3\u30b0 \u30b7\u30b9\u30c6\u30e0\u5185\u306e\u3059\u3079\u3066\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4e00\u6642\u505c\u6b62\u3057\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u306f\u6700\u521d\u306b\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306b\u5fdc\u7b54\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p> Sub ApplicationModal()MsgBox Prompt := \u00bb\u3053\u308c\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3 \u30e2\u30fc\u30c0\u30eb\u3067\u3059\u00bb, _Buttons :=vbOK + vbApplicationModal, _Title := \u00bbMsgBox \u00bbEnd Sub <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> \uff0317\u3002 vbMsgBox\u30d8\u30eb\u30d7\u30dc\u30bf\u30f3<\/h3><p>\u3053\u306e\u5b9a\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u306b\u30d8\u30eb\u30d7 \u30dc\u30bf\u30f3\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u30d8\u30eb\u30d7 \u30d5\u30a1\u30a4\u30eb\u3068\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u756a\u53f7\u3092\u8ffd\u52a0\u3057\u3066\u3001\u30d8\u30eb\u30d7 \u30dc\u30bf\u30f3\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p><p> Sub HelpButton()MsgBox Prompt:=\u201d\u30d8\u30eb\u30d7 \u30dc\u30bf\u30f3\u3092\u4f7f\u7528\u201d, _Buttons:=vbOK + vbMsgBoxHelpButton, _Title:=\u201dMsgBox\u201d, _HelpFile:=\u201dC:UsersPuneet GogiaDesktopsamplehelp.chm\u201d, _Context:=101End Sub<\/p><p>\u30e6\u30fc\u30b6\u30fc\u304c\u30d8\u30eb\u30d7 \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30d8\u30eb\u30d7 \u30e1\u30cb\u30e5\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #18. vbMsgBoxSetForeground<\/h3><p>\u3053\u306e\u5b9a\u6570\u306f\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9 \u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u6700\u524d\u9762\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p><p> Sub SetForeground()MsgBox Prompt:=\u201d\u3053\u306e MsgBox \u306f\u524d\u666f\u306b\u3042\u308a\u307e\u3059\u201d, _Buttons:=vbOK + vbMsgBoxSetForeground, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #19. vbMsgBoxRight<\/h3><p>\u3053\u306e\u5b9a\u6570\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u30c6\u30ad\u30b9\u30c8\u304c\u53f3\u63c3\u3048\u306b\u306a\u308a\u307e\u3059\u3002<\/p><p> MsgBoxRight() \u306e\u4e0b<\/p><p>MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := \u201c\u30c6\u30ad\u30b9\u30c8\u306f\u53f3\u5074\u306b\u3042\u308a\u307e\u3059\u201d, _<\/p><p>\u30dc\u30bf\u30f3:=vbOK + vbMsgBoxRight\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> \uff0320\u3002 vbMsgBoxRtl\u8aad\u66f8<\/h3><p>\u3053\u306e\u5b9a\u6570\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u304c\u53f3\u306b\u53cd\u8ee2\u3057\u307e\u3059\u3002\u3053\u306e\u5b9a\u6570\u306f\u4e3b\u306b\u30d8\u30d6\u30e9\u30a4\u8a9e\u304a\u3088\u3073\u30a2\u30e9\u30d3\u30a2\u8a9e\u30b7\u30b9\u30c6\u30e0\u7528\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p><p> MsgBoxRtlRead() \u306e\u4e0b<\/p><p>MsgBox \u30d7\u30ed\u30f3\u30d7\u30c8 := \u300c\u3053\u306e\u7bb1\u306f\u3072\u3063\u304f\u308a\u8fd4\u308a\u307e\u3057\u305f\u300d, _<\/p><p>\u30dc\u30bf\u30f3:=vbOK + vbMsgBoxRtlRead\u3001_<\/p><p>\u30bf\u30a4\u30c8\u30eb: = \u300c\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h2 id=\"tab-con-8\" style=\"margin-bottom: 20px !important;\" data-fontsize=\"28\" data-lineheight=\"42\">\u623b\u308a\u5024<\/h2><p>\u30e6\u30fc\u30b6\u30fc\u304c\u3044\u305a\u308c\u304b\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306b\u5fdc\u7b54\u3059\u308b\u305f\u3073\u306b\u3001\u756a\u53f7\u304c\u751f\u6210\u3055\u308c\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u304c\u3069\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u304b\u3092\u8b58\u5225\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002 <\/p><table class=\"mtr-table mtr-thead-th\" style=\"margin-top: 0px !important; margin-bottom: 20px !important;\" data-rows=\"8\" data-cols=\"3\" data-tve-custom-colour=\"16460717\"><thead><tr><th class=\"mtr-th-tag\" data-tve-custom-colour=\"55690541\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\">\u7d76\u3048\u9593\u306a\u3044<\/div><\/th><th class=\"mtr-th-tag\" data-tve-custom-colour=\"29870761\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\">\u4fa1\u5024<\/div><\/th><th class=\"mtr-th-tag\" data-tve-custom-colour=\"55301951\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\">\u8aac\u660e<\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"41996507\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vbOK <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"28891566\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 1 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"50801664\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\">\u3088\u3057<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"98145453\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb\u30ad\u30e3\u30f3\u30bb\u30eb<\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"35044744\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 2 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"33697450\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\">\u30ad\u30e3\u30f3\u30bb\u30eb<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"29220062\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb\u4e2d\u6b62<\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"44631822\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 3 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"87798468\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\">\u4e2d\u7d76<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"67330579\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb\u3082\u3046\u4e00\u5ea6\u8a66\u3057\u3066\u304f\u3060\u3055\u3044<\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"714382\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 4 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"97829037\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\">\u518d\u958b\u3059\u308b<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"24936662\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb\u30b9\u30ad\u30c3\u30d7<\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"51432601\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 5 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"26493383\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\">\u7121\u8996\u3059\u308b<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"52901802\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb\u306f\u3044<\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"48521301\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 6 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"67193381\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\">\u306f\u3044<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"24036290\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb\u3044\u3044\u3048<\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"22797535\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 7 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"48971731\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\">\u3044\u3044\u3048<\/div><\/td><\/tr><\/tbody><\/table><h2>Excel \u3067\u306e VBA \u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u95a2\u6570\u306e\u5b9f\u969b\u306e\u4f7f\u7528\u4f8b<\/h2><p>\u3053\u3053\u3067\u306f\u3001\u5b9f\u969b\u306e VBA \u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306e\u4f8b\u3092\u3044\u304f\u3064\u304b\u30ea\u30b9\u30c8\u3057\u307e\u3057\u305f\u3002\u3053\u308c\u3089\u306e\u4f8b\u306f\u3001\u304d\u3063\u3068\u4f7f\u7528\u3059\u308b\u304d\u3063\u304b\u3051\u306b\u306a\u308b\u3067\u3057\u3087\u3046\u3002 <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #1. VBA MsgBox \u3092\u4f7f\u7528\u3057\u3066\u30de\u30af\u30ed\u3092\u5b9f\u884c\u3059\u308b<\/h3><p>msgbox \u95a2\u6570\u306e\u52a9\u3051\u3092\u501f\u308a\u3066\u3001\u30de\u30af\u30ed\u3092\u5b9f\u884c\u3059\u308b\u524d\u306b\u30e6\u30fc\u30b6\u30fc\u306b\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u8868\u793a\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u7406\u89e3\u3059\u308b\u305f\u3081\u306b\u4ee5\u4e0b\u306e\u30de\u30af\u30ed\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p><p> SaveThis() \u306e\u4e0b<\/p><p>\u6574\u6570\u3068\u3057\u3066\u306e Dim \u7d50\u679c<\/p><p>Result = MsgBox(\u201c\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4fdd\u5b58\u3057\u307e\u3059\u304b?\u201d, vbOKCancel)<\/p><p>\u7d50\u679c = vbOK \u306e\u5834\u5408<\/p><p>ActiveWorkbook.Save<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-le-classeur-avec-vba-msgbox.png\" sizes=\"auto, \" srcset=\"\" alt=\"VBA msgbox \u3067\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092\u4fdd\u5b58\u3059\u308b\" width=\"237\" height=\"143\" data-attachment-id=\"14848\"><\/p><p>\u30e6\u30fc\u30b6\u30fc\u306b\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092\u4fdd\u5b58\u3059\u308b\u3088\u3046\u4f9d\u983c\u3067\u304d\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u304c\u300cOK\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30de\u30af\u30ed \u30b3\u30fc\u30c9\u306b\u3088\u3063\u3066\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u304c\u4fdd\u5b58\u3055\u308c\u307e\u3059\u3002 <\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #2.\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u633f\u5165\u3059\u308b<\/h3><p>vbTab \u3092\u4f7f\u7528\u3057\u3066\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306b\u8868\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u4f8b\u3067\u306f\u3001\u8868\u306f\u30bb\u30eb A1 \u304b\u3089\u59cb\u307e\u308a\u307e\u3059\u3002 <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-onglet-dans-vba-msgbox.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"333\" height=\"308\" data-attachment-id=\"14850\"><\/p><p> AddToMsgBox() \u306e\u4e0b<\/p><p>\u6587\u5b57\u5217\u3068\u3057\u3066\u306e\u8584\u6697\u3044\u30e1\u30c3\u30bb\u30fc\u30b8<\/p><p>Dim r as int<\/p><p> Dim c as int<\/p><p> Dim rc \u3092 int \u3068\u3057\u3066\u6307\u5b9a\u3059\u308b<\/p><p>Dim cc as int<\/p><p> myRows \u3092\u7bc4\u56f2\u3068\u3057\u3066\u6697\u304f\u3059\u308b<\/p><p>myColumns \u3092\u7bc4\u56f2\u3068\u3057\u3066\u6697\u304f\u3059\u308b<\/p><p>\u30e1\u30c3\u30bb\u30fc\u30b8 = &#8220;&#8221;<\/p><p> myRows = Range(\u201cA:A\u201d) \u3092\u8a2d\u5b9a\u3057\u307e\u3059<\/p><p>myColumns = Range(\u201c1:1\u201d) \u3092\u8a2d\u5b9a\u3057\u307e\u3059<\/p><p>rc = Application.CountA(myRows)<\/p><p> cc = Application.CountA(myColumns)<\/p><p> r = 1 \uff5e rc \u306e\u5834\u5408 c = 1 \uff5e cc \u306e\u5834\u5408<\/p><p>Msg = \u30e1\u30c3\u30bb\u30fc\u30b8 &amp; Cells(r, c).Text<\/p><p> c &lt;= cc \u306e\u5834\u5408<\/p><p>\u30e1\u30c3\u30bb\u30fc\u30b8 = \u30e1\u30c3\u30bb\u30fc\u30b8 &amp; vbTab<\/p><p>\u6b21\u306e cMsg = Msg &amp; vbCrLf<\/p><p>\u6b21\u306er<\/p><p>\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u30e1\u30c3\u30bb\u30fc\u30b8<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #3.\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u3068\u304d\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u3092\u8868\u793a\u3059\u308b<\/h3><p>\u4ee5\u4e0b\u306e\u30de\u30af\u30ed\u3092\u898b\u308b\u3068\u3001auto_open \u3092\u4f7f\u7528\u3057\u3066\u3001\u30d6\u30c3\u30af\u3092\u958b\u3044\u305f\u3068\u304d\u306b\u8868\u793a\u3059\u308b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/p><p> auto_open() \u306e\u4e0b\u3067<\/p><p>MsgBox \u300cExceladvisor \u3078\u3088\u3046\u3053\u305d\u3002\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u3044\u305f\u3060\u304d\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002\u300d _<\/p><p> + vbNewLine + vbNewLine + \u300c\u3053\u3053\u3067\u306f\u3001MsgBox \u95a2\u6570\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u8aac\u660e\u3057\u307e\u3059\u3002 \u00bb _<\/p><p> + vbNewLine + vbNewLine + \u300c\u305d\u3057\u3066\u3001\u4ed6\u306e\u7d20\u6674\u3089\u3057\u3044\u3082\u306e\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u3053\u3068\u3092\u5fd8\u308c\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002 \u00bb<\/p><p>\u30a8\u30f3\u30c7\u30a3\u30f3\u30b0\u30b5\u30d6\u30bf\u30a4\u30c8\u30eb<\/p><h2 data-fontsize=\"26\" data-lineheight=\"39\">\u30c6\u30a4\u30af\u30a2\u30a6\u30c8<\/h2><ol><li>\u30d8\u30eb\u30d7 \u30dc\u30bf\u30f3\u3092 4 \u756a\u76ee\u306e\u30dc\u30bf\u30f3\u3068\u3057\u3066\u4f7f\u7528\u3057\u306a\u3044\u5834\u5408\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306b 4 \u3064\u306e\u30dc\u30bf\u30f3\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002<\/li><li>\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306e\u30d8\u30eb\u30d7 \u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u30b5\u30f3\u30d7\u30eb \u30d5\u30a1\u30a4\u30eb\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li><\/ol><h2 data-fontsize=\"28\" data-lineheight=\"42\">\u30b5\u30f3\u30d7\u30eb\u30d5\u30a1\u30a4\u30eb<\/h2><p>\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f<a style=\"outline: none;\" spellcheck=\"false\" href=\"http:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/msgbox.zip\" rel=\"nofollow\" data-wpel-link=\"internal\" data-ms-editor=\"true\">\u3001\u3053\u3053\u304b\u3089\u3053\u306e\u30b5\u30f3\u30d7\u30eb \u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044<\/a>\u3002<\/p><h2 data-fontsize=\"26\" data-lineheight=\"39\">\u7d50\u8ad6<\/h2><p>\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306f\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u4f1d\u3048\u308b\u3060\u3051\u3067\u306a\u304f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u30af\u30ea\u30a8\u30a4\u30c6\u30a3\u30d6\u306a\u5370\u8c61\u3092\u4e0e\u3048\u307e\u3059\u3002\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u9001\u4fe1\u3059\u308b\u3068\u3001\u7c21\u5358\u306a\u5fdc\u7b54\u304c\u5f97\u3089\u308c\u307e\u3059\u3002<\/p><p>\u5148\u307b\u3069\u3082\u8ff0\u3079\u305f\u3088\u3046\u306b\u3001VBA \u3092\u521d\u3081\u3066\u4f7f\u7528\u3059\u308b\u5834\u5408\u306f\u3001\u30e1\u30c3\u30bb\u30fc\u30b8 \u30dc\u30c3\u30af\u30b9\u306e\u4f7f\u7528\u65b9\u6cd5\u3092\u5b66\u3076\u3053\u3068\u304c\u6700\u5584\u306e\u65b9\u6cd5\u306e 1 \u3064\u3067\u3059\u3002\u3053\u306e\u8a18\u4e8b\u304c\u3001VBA \u3092\u30de\u30b9\u30bf\u30fc\u3059\u308b\u3068\u3044\u3046\u5922\u306b\u8fd1\u3065\u304f\u306e\u306b\u5f79\u7acb\u3064\u3053\u3068\u3092\u9858\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u3053\u3053\u3067 1 \u3064\u3060\u3051\u8a00\u308f\u305b\u3066\u304f\u3060\u3055\u3044\u3002<\/p><p> <em>MsgBox \u95a2\u6570\u306f VBA \u3067\u6700\u3082\u512a\u308c\u305f\u6a5f\u80fd\u306e 1 \u3064\u3060\u3068\u601d\u3044\u307e\u3059\u304b?<\/em><\/p><p>\u305c\u3072\u30b3\u30e1\u30f3\u30c8\u6b04\u3067\u3054\u610f\u898b\u3092\u79c1\u3068\u5171\u6709\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u305c\u3072\u3054\u610f\u898b\u3092\u304a\u5f85\u3061\u3057\u3066\u304a\u308a\u307e\u3059\u3002\u3053\u306e\u30d2\u30f3\u30c8\u3092\u304a\u53cb\u9054\u3068\u5171\u6709\u3059\u308b\u3053\u3068\u3082\u5fd8\u308c\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p><p> <strong>VBA \u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u308b<\/strong><\/p><ul><li><a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/ja\/\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u8ffd\u52a0-1\/\" data-wpel-link=\"internal\">VBA\u3092\u4f7f\u7528\u3057\u3066\u540d\u524d\u3092\u4ed8\u3051\u3066\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u8ffd\u52a0\u3057\u307e\u3059<\/a><\/li><li><a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/ja\/\u30de\u30af\u30ed\u3092\u8a18\u9332\u3059\u308b\/\" data-wpel-link=\"internal\">Excel\u3067\u30de\u30af\u30ed\u3092\u8a18\u9332\u3059\u308b\u65b9\u6cd5<\/a><\/li><li>\u660e\u793a\u7684\u306a VBA \u30aa\u30d7\u30b7\u30e7\u30f3<\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3316","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?<\/title>\n<meta name=\"description\" content=\"VBA MsgBox \u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u914d\u4fe1\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u306e\u5fdc\u7b54\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30b7\u30f3\u30d7\u30eb\u306a\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7 \u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u3059\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/ja\/vba\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?\" \/>\n<meta property=\"og:description\" content=\"VBA MsgBox \u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u914d\u4fe1\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u306e\u5fdc\u7b54\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30b7\u30f3\u30d7\u30eb\u306a\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7 \u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u3059\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ja\/vba\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-07T04:48:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/\",\"url\":\"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/\",\"name\":\"Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\",\"datePublished\":\"2023-10-31T18:23:37+00:00\",\"dateModified\":\"2023-12-07T04:48:57+00:00\",\"description\":\"VBA MsgBox \u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u914d\u4fe1\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u306e\u5fdc\u7b54\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30b7\u30f3\u30d7\u30eb\u306a\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7 \u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u3059\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u5bb6\",\"item\":\"https:\/\/exceladvisor.org\/ja\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ja\/\",\"name\":\"Excel Advisor\",\"description\":\"\u30c7\u30fc\u30bf\u3092\u652f\u914d\u3059\u308b\u305f\u3081\u306e\u7a76\u6975\u306e\u30ac\u30a4\u30c9!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ja\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ja\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?","description":"VBA MsgBox \u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u914d\u4fe1\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u306e\u5fdc\u7b54\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30b7\u30f3\u30d7\u30eb\u306a\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7 \u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u3059\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/ja\/vba\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\/","og_locale":"ja_JP","og_type":"article","og_title":"Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?","og_description":"VBA MsgBox \u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u914d\u4fe1\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u306e\u5fdc\u7b54\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30b7\u30f3\u30d7\u30eb\u306a\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7 \u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u3059\u3002","og_url":"https:\/\/exceladvisor.org\/ja\/vba\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-07T04:48:57+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/","url":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/","name":"Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ja\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png","datePublished":"2023-10-31T18:23:37+00:00","dateModified":"2023-12-07T04:48:57+00:00","description":"VBA MsgBox \u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u914d\u4fe1\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u306e\u5fdc\u7b54\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30b7\u30f3\u30d7\u30eb\u306a\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7 \u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u3059\u3002","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/ja\/vba%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u5bb6","item":"https:\/\/exceladvisor.org\/ja\/"},{"@type":"ListItem","position":2,"name":"Excel\u3067\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ja\/#website","url":"https:\/\/exceladvisor.org\/ja\/","name":"Excel Advisor","description":"\u30c7\u30fc\u30bf\u3092\u652f\u914d\u3059\u308b\u305f\u3081\u306e\u7a76\u6975\u306e\u30ac\u30a4\u30c9!","publisher":{"@id":"https:\/\/exceladvisor.org\/ja\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ja\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ja\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ja\/","logo":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/3316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/comments?post=3316"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/3316\/revisions"}],"predecessor-version":[{"id":3927,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/3316\/revisions\/3927"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/media?parent=3316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}