{"id":6411,"date":"2026-02-05T13:05:38","date_gmt":"2026-02-05T04:05:38","guid":{"rendered":"https:\/\/www.bold.ne.jp\/engineer-club\/?p=6411"},"modified":"2026-01-28T16:59:23","modified_gmt":"2026-01-28T07:59:23","slug":"vba-like-operatorexplanation-examples","status":"publish","type":"post","link":"https:\/\/www.bold.ne.jp\/engineer-club\/vba-like-operatorexplanation-examples","title":{"rendered":"VBA\u306eLike\u6f14\u7b97\u5b50\u3068\u306f\uff1f\u89e3\u8aac\u3068\u4f7f\u7528\u4f8b"},"content":{"rendered":"<p>\u306f\u3058\u3081\u306b<br \/>\nVBA\u306e\u51e6\u7406\u3067\u3001\u300c\u30c7\u30fc\u30bf\u306e\u6bd4\u8f03\u3092\u884c\u3044\u305f\u3044\u300d\u300c\u30c7\u30fc\u30bf\u306e\u90e8\u5206\u4e00\u81f4\u3067\u5224\u5225\u3057\u305f\u3044\u300d\u3068\u601d\u3063\u305f\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304b\uff1f<br \/>\n\u3053\u3053\u3067\u306f\u3001\u6bd4\u8f03\u3092\u884c\u3046\u6f14\u7b97\u5b50\u300cLike\u300d\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">\u76ee\u6b21<\/p><ul class=\"toc_list\"><li><a href=\"#Like\">\uff11\uff0eLike\u6f14\u7b97\u5b50\u306b\u3064\u3044\u3066<\/a><ul><li><a href=\"#-Like\">\uff11-\uff11\uff0eLike\u6f14\u7b97\u5b50\u3068\u306f<\/a><\/li><li><a href=\"#-Like-2\">\uff11-\uff12\uff0eLike\u6f14\u7b97\u5b50\u306e\u69cb\u6587<\/a><\/li><\/ul><\/li><li><a href=\"#Like-2\">\uff12\uff0eLike\u6f14\u7b97\u5b50\u306e\u4f7f\u7528\u4f8b<\/a><ul><li><a href=\"#i\">\uff12-\uff11\uff0e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/a><\/li><li><a href=\"#i-2\">\uff12-\uff12\uff0e\u7279\u6b8a\u306a\u66f8\u304d\u65b9\u3092\u3059\u308b\u5834\u5408<\/a><\/li><li><a href=\"#i-3\">\uff12-\uff13\uff0e\u305d\u306e\u4ed6<\/a><\/li><\/ul><\/li><li><a href=\"#i-4\">\uff13\uff0e\u6700\u5f8c\u306b<\/a><\/li><\/ul><\/div>\n<h2><span id=\"Like\">\uff11\uff0eLike\u6f14\u7b97\u5b50\u306b\u3064\u3044\u3066<\/span><\/h2>\n<h3><span id=\"-Like\">\uff11-\uff11\uff0eLike\u6f14\u7b97\u5b50\u3068\u306f<\/span><\/h3>\n<p><strong><\/strong><span class=\"f-marker-p\"><strong>Like\u6f14\u7b97\u5b50\u306f\u30012\u3064\u306e\u6587\u5b57\u5217\u3092\u6bd4\u8f03\u3059\u308b\u6f14\u7b97\u5b50\u3067\u3059\u3002<\/strong><\/span><br \/>\n\u6f14\u7b97\u5b50\u306a\u306e\u3067\u3001\u300c&lt;\u300d\u300c&gt;\u300d\u300c=\u300d\u300c!=\u300d\u306e\u3088\u3046\u306a\u4f7f\u3044\u65b9\u3092\u3057\u307e\u3059\u3002<br \/>\n\u307e\u305f\u3001\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u3092\u7528\u3044\u3066\u6587\u5b57\u5217\u3092\u542b\u3080\u304b\u306e\u5224\u5b9a\u306b\u3082\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3><span id=\"-Like-2\">\uff11-\uff12\uff0eLike\u6f14\u7b97\u5b50\u306e\u69cb\u6587<\/span><\/h3>\n<p>[\u6587\u5b57\u5217A] Like [\u6587\u5b57\u5217B]<br \/>\n<span class=\"f-marker-p\">\u623b\u308a\u5024\u306f\u3001\u4e00\u81f4\u3057\u305f\u3089\u3001true<\/span><br \/>\n<span class=\"f-marker-w\">\u4e00\u81f4\u3057\u306a\u304b\u3063\u305f\u3089\u3001false<\/span><br \/>\n\u6bd4\u8f03\u3059\u308b\u6587\u5b57\u5217\u306e\u3069\u3061\u3089\u304b\u304cNull\u306a\u3089Null<\/p>\n<h2><span id=\"Like-2\">\uff12\uff0eLike\u6f14\u7b97\u5b50\u306e\u4f7f\u7528\u4f8b<\/span><\/h2>\n<h3><span id=\"i\">\uff12-\uff11\uff0e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/span><\/h3>\n<pre class=\"prettyprint lang:default decode:true\">Sub main1()\r\n    Dim str1 As String\r\n    Dim str2 As String\r\n    Dim ret As String\r\n    \r\n    str1 = \"123456\"\r\n    str2 = \"123456\"\r\n    \r\n    ret = str1 Like str2\r\n    \r\n    If ret = True Then\r\n        MsgBox \"\u300c\" + str1 + \"\u300d\u3068\u300c\" + str2 + \"\u300d\u306f\u540c\u4e00\u3067\u3059\"\r\n    ElseIf ret = False Then\r\n        MsgBox \"\u300c\" + str1 + \"\u300d\u3068\u300c\" + str2 + \"\u300d\u306f\u7570\u306a\u308a\u307e\u3059\"\r\n    End If\r\n    \r\nEnd Sub\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h3><span id=\"i-2\">\uff12-\uff12\uff0e\u7279\u6b8a\u306a\u66f8\u304d\u65b9\u3092\u3059\u308b\u5834\u5408<\/span><\/h3>\n<h4>\uff12-\uff12-\uff11\uff0e\u6307\u5b9a\u3057\u305f\u6587\u5b57\u5217\u3092\u542b\u3080\u304b\u306e\u30c1\u30a7\u30c3\u30af<\/h4>\n<pre class=\"prettyprint lang:default decode:true\">Sub main2()\r\n    Dim str1 As String\r\n    Dim str2 As String\r\n    Dim ret As String\r\n    \r\n    str1 = \"123456\"\r\n    str2 = \"1234*\"\r\n    \r\n    ret = str1 Like str2\r\n    \r\n    If ret = True Then\r\n        MsgBox \"\u300c\" + str1 + \"\u300d\u306f\u300c\" + str2 + \"\u300d\u3092\u542b\u307f\u307e\u3059\"\r\n    ElseIf ret = False Then\r\n        MsgBox \"\u300c\" + str1 + \"\u300d\u306f\u300c\" + str2 + \"\u300d\u542b\u307f\u307e\u305b\u3093\"\r\n    End If\r\n    \r\nEnd Sub\r\n<\/pre>\n<h4>\uff12-\uff12-\uff12\uff0e\u6841\u6570\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/h4>\n<pre class=\"prettyprint lang:default decode:true\">Sub main3()\r\n    Dim str1 As String\r\n    Dim ret As String\r\n    \r\n    str1 = \"123456\"\r\n    \r\n    ret = str1 Like \"######\"\r\n    \r\n    If ret = True Then\r\n        MsgBox \"\u6841\u6570\u304c\u4e00\u81f4\u3057\u307e\u3059\"\r\n    ElseIf ret = False Then\r\n        MsgBox \"\u6841\u6570\u304c\u4e00\u81f4\u3057\u307e\u305b\u3093\"\r\n    End If\r\n    \r\nEnd Sub\r\n<\/pre>\n<h3><span id=\"i-3\">\uff12-\uff13\uff0e\u305d\u306e\u4ed6<\/span><\/h3>\n<p>\u5b8c\u5168\u4e00\u81f4\u306e\u307f\u3092\u884c\u3046\u5834\u5408\u306f\u3001Like\u6f14\u7b97\u5b50\u3092\u4f7f\u308f\u306a\u304f\u3066\u3082\u3001\u4e0b\u8a18\u306e\u69d8\u306a\u5f0f\u3067\u3082\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<pre class=\"prettyprint lang:default decode:true\">\u3000Range([\u6bd4\u8f03\u3057\u305f\u3044\u6587\u5b57\u5217\uff11]) = [\u6bd4\u8f03\u3057\u305f\u3044\u6587\u5b57\u5217\uff12]<\/pre>\n<h2><span id=\"i-4\">\uff13\uff0e\u6700\u5f8c\u306b<\/span><\/h2>\n<p>Like\u6f14\u7b97\u5b50\u306f\u3001\u5358\u7d14\u306a\u6bd4\u8f03\u306a\u3089\u4ed6\u306e\u95a2\u6570\u7b49\u3092\u4f7f\u3048\u307e\u3059\u304c\u3001\u90e8\u5206\u4e00\u81f4\u7b49\u4f7f\u7528\u7bc4\u56f2\u304c\u5e83\u3044\u6f14\u7b97\u5b50\u3067\u3059\u3002<br \/>\n\u3053\u3053\u3067\u8aac\u660e\u3057\u305f\u4ee5\u5916\u306b\u3082\u7528\u9014\u306f\u305f\u304f\u3055\u3093\u3042\u308b\u306e\u3067\u3001\u3053\u3053\u3092\u304d\u3063\u304b\u3051\u306b\u8abf\u3079\u3066\u307f\u305f\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u306f\u3058\u3081\u306b VBA\u306e\u51e6\u7406\u3067\u3001\u300c\u30c7\u30fc\u30bf\u306e\u6bd4\u8f03\u3092\u884c\u3044\u305f\u3044\u300d\u300c\u30c7\u30fc\u30bf\u306e\u90e8\u5206\u4e00\u81f4\u3067\u5224\u5225\u3057\u305f\u3044\u300d\u3068\u601d\u3063\u305f\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304b\uff1f \u3053\u3053\u3067\u306f\u3001\u6bd4\u8f03\u3092\u884c\u3046\u6f14\u7b97\u5b50\u300cLike\u300d\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u3066\u3044\u304d\u307e\u3059\u3002 \u76ee\u6b21\uff11\uff0eLike\u6f14\u7b97\u5b50\u306b\u3064\u3044\u3066\uff11-\uff11\uff0eL [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":4244,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18,11],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/6411"}],"collection":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/comments?post=6411"}],"version-history":[{"count":2,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/6411\/revisions"}],"predecessor-version":[{"id":6413,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/6411\/revisions\/6413"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media\/4244"}],"wp:attachment":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media?parent=6411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/categories?post=6411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}