{"id":113,"date":"2025-06-01T22:47:50","date_gmt":"2025-06-01T13:47:50","guid":{"rendered":"https:\/\/aisleblog.com\/?p=113"},"modified":"2025-06-07T19:30:59","modified_gmt":"2025-06-07T10:30:59","slug":"vba%e3%81%ae%e5%9f%ba%e7%a4%8e","status":"publish","type":"post","link":"https:\/\/aisleblog.com\/?p=113","title":{"rendered":"\u7b2c1\u56de\u300c\u30eb\u30fc\u30d7\u51e6\u7406\u3001\u6761\u4ef6\u5206\u5c90\u300d"},"content":{"rendered":"\n

\u30eb\u30fc\u30d7\u51e6\u7406<\/h3>\n\n\n\n

\u30fbFor\u6587<\/p>\n\n\n\n

Dim i As Integer\nFor i = 1 To 5\n    MsgBox \"\u30ab\u30a6\u30f3\u30c8: \" & i\nNext i\n<\/code><\/pre><\/section>\n\n\n\n
\u30fbDo While\u6587<\/p>\n\n\n\n
Dim i As Integer\ni = 1\nDo While i <= 5\n    MsgBox \"Do While: \" & i\n    i = i + 1\nLoop\n<\/code><\/pre><\/section>\n\n\n\n
\u6761\u4ef6\u5206\u5c90<\/h3>\n\n\n\n
\u30fbIf\u6587<\/p>\n\n\n\n
Dim x As Integer\nx = 5\nIf x > 3 Then\n    MsgBox \"3\u3088\u308a\u5927\u304d\u3044\"\nElse\n    MsgBox \"3\u4ee5\u4e0b\"\nEnd If\n<\/code><\/pre><\/section>\n\n\n\n
\u30fbSelect Case<\/p>\n\n\n\n
Dim fruit As String\nfruit = \"\u308a\u3093\u3054\"\n\nSelect Case fruit\n    Case \"\u308a\u3093\u3054\"\n        MsgBox \"\u3053\u308c\u306f\u308a\u3093\u3054\u3067\u3059\"\n    Case \"\u307f\u304b\u3093\"\n        MsgBox \"\u3053\u308c\u306f\u307f\u304b\u3093\u3067\u3059\"\n    Case Else\n        MsgBox \"\u4e0d\u660e\u306a\u679c\u7269\u3067\u3059\"\nEnd Select\n<\/code><\/pre><\/section>\n\n\n\n
\u6bd4\u8f03\u6f14\u7b97\u5b50\u3068\u8ad6\u7406\u6f14\u7b97\u5b50<\/h3>\n\n\n\n
\u30fb\u6bd4\u8f03\u6f14\u7b97\u5b50<\/p>\n\n\n\n
\u6f14\u7b97\u5b50<\/th>\u610f\u5473<\/th>\u4f8b<\/th><\/tr><\/thead>
=<\/td>\u7b49\u3057\u3044<\/td>a = b<\/td><\/tr>
<><\/td>\u7b49\u3057\u304f\u306a\u3044<\/td>a <> b<\/td><\/tr>
<<\/td>\uff5e\u3088\u308a\u5c0f\u3055\u3044<\/td>a < b<\/td><\/tr>
><\/td>\uff5e\u3088\u308a\u5927\u304d\u3044<\/td>a > b<\/td><\/tr>
<=<\/td>\u4ee5\u4e0b<\/td>a <= b<\/td><\/tr>
>=<\/td>\u4ee5\u4e0a<\/td>a >= b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\u30fb\u8ad6\u7406\u6f14\u7b97\u5b50<\/p>\n\n\n\n
\u6f14\u7b97\u5b50<\/th>\u610f\u5473<\/th>\u4f8b<\/th><\/tr><\/thead>
And<\/td>\u4e21\u65b9\u304cTrue\u306a\u3089True<\/td>If a > 0 And b > 0 Then<\/td><\/tr>
Or<\/td>\u3069\u3061\u3089\u304b\u304cTrue\u306a\u3089True<\/td>If a > 0 Or b > 0 Then<\/td><\/tr>
Not<\/td>\uff5e\u3067\u306f\u306a\u3044<\/td>If Not a = 0 Then<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u30eb\u30fc\u30d7\u51e6\u7406 \u30fbFor\u6587 \u30fbDo While\u6587 \u6761\u4ef6\u5206\u5c90 \u30fbIf\u6587 \u30fbSelect Case \u6bd4\u8f03\u6f14\u7b97\u5b50\u3068\u8ad6\u7406\u6f14\u7b97\u5b50 \u30fb\u6bd4\u8f03\u6f14\u7b97\u5b50 \u6f14\u7b97\u5b50 \u610f\u5473 \u4f8b = \u7b49\u3057\u3044 a = b <> \u7b49\u3057\u304f\u306a\u3044 a <&gt […]<\/p>\n","protected":false},"author":1,"featured_media":146,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jinr_url_youtube":"","_jinr_pip_youtube":false,"_jinr_time_youtube":"","_jinr_thumb_youtube":"","_jinr_media_youtube":"","_jinr_category_edit":false,"_jinr_category":"","_jinr_title_display":false,"_jinr_snsbutton_display":false,"_jinr_ads_display":false,"_jinr_thumbnail_display":false,"_jinr_profile_display":false,"_jinr_representations_display":false,"_jinr_relatedpost_display":false,"_jinr_sidebar1col_display":false,"_jinr_sidebar2col_display":false,"_jinr_seotitle_display":"","_jinr_description_display":"","_jinr_keyword_display":"","_jinr_hastag_display":"","_jinr_canonical_display":"","_jinr_noindex_display":false,"_jinr_paidpost":false,"_jinr_paidpost_product_id":"","_jinr_headtag_article":"","_jinr_ogp_image_url":"","_jinr_last_featured_id":0,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"views":"21","_links":{"self":[{"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=113"}],"version-history":[{"count":16,"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":149,"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions\/149"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/media\/146"}],"wp:attachment":[{"href":"https:\/\/aisleblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}