EXCEL\u306eVBA\u3067\u4f7f\u3048\u308b\u95a2\u6570\u985e\u30e1\u30e2\u3092\u6b8b\u3057\u3066\u304a\u304d\u307e\u3059\u3002
\n\u3053\u308c\u306f\u30bb\u30eb\u306e\u6587\u5b57\u5217\u306b\u534a\u89d2\u30ab\u30ca\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u30a8\u30e9\u30fc\u3092\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002<\/p>\n
\u30bb\u30eb\u306e\u6587\u5b57\u5217\u3092\uff11\u6587\u5b57\u3065\u3064\u534a\u89d2\u30ab\u30ca\u304b\u3069\u3046\u304b\u3092\u5224\u5b9a\u3057\u3001\u898b\u3064\u304b\u3063\u305f\u6642\u70b9\u3067False\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n
\u3059\u3079\u3066\u306e\u6587\u5b57\u5217\u304c\u5168\u89d2\u306e\u5834\u5408\u306fTrue\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n
\u4f5c\u6210\u3057\u305f\u30c4\u30fc\u30eb\u306e\u4fbf\u5b9c\u4e0a\u3001\u82f1\u6570\u8a18\u53f7\u306f\u534a\u89d2\u3067\u3082OK\u3068\u3057\u3066\u3044\u307e\u3059\u3002
\n\u5224\u65ad\u306e\u9806\u306f\u53d6\u5f97\u3057\u305f\u6587\u5b57\u30b3\u30fc\u30c9\u304cS-JIS\u306e\u534a\u89d2\u30ab\u30ca\u306b\u542b\u307e\u308c\u308b\u304b\u3069\u3046\u304b\u3067\u3059\u3002
\n-[Sample\u3000Code]————————–
\nFunction AscEx(strOrg As String) As Boolean<\/p>\n
Dim intLoop As Integer
\nDim strChar As String<\/p>\n
AscEx = True
\nFor intLoop = 1 To Len(strOrg)<\/p>\n
strChar = Mid(strOrg, intLoop, 1)<\/p>\n
If ((Asc(strChar) >= &HA9) And (Asc(strChar) <= &HDF)) Then
\nAscEx = False
\nEnd If<\/p>\n
Next intLoop<\/p>\n
End Function
\n————————-<\/p>\n
\u203b\u672c\u30b5\u30f3\u30d7\u30eb\u30b2\u30fc\u30e0\u30d7\u30ed\u30b0\u30e9\u30e0\u304a\u3088\u3073\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066\u767a\u751f\u3057\u305f\u969c\u5bb3\uff0c\u554f\u984c\u306a\u3069\u306b\u95a2\u3057\u3066\uff0c(\u6709)CORALNET\u306f\u4e00\u5207\u306e\u8cac\u4efb\u3092\u8ca0\u3044\u307e\u305b\u3093\u3002\u4f7f\u7528\u306f\u3054\u81ea\u8eab\u306e\u8cac\u4efb\u3067\u884c\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
EXCEL\u306eVBA\u3067\u4f7f\u3048\u308b\u95a2\u6570\u985e\u30e1\u30e2\u3092\u6b8b\u3057\u3066\u304a\u304d\u307e\u3059\u3002 \u3053\u308c\u306f\u30bb\u30eb\u306e\u6587\u5b57\u5217\u306b\u534a\u89d2\u30ab\u30ca\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u30a8\u30e9\u30fc\u3092\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002 \u30bb\u30eb\u306e\u6587\u5b57\u5217\u3092\uff11\u6587\u5b57\u3065\u3064\u534a\u89d2\u30ab\u30ca\u304b\u3069\u3046\u304b\u3092\u5224\u5b9a\u3057\u3001\u898b\u3064\u304b\u3063\u305f\u6642\u70b9\u3067False\u3092\u8fd4\u3057\u307e\u3059\u3002 \u3059\u3079…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_lmt_disableupdate":"no","_lmt_disable":"","footnotes":""},"categories":[134],"tags":[46,148],"class_list":{"0":"post-71","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-pc","7":"tag-excel","8":"tag-148","9":"article"},"aioseo_notices":[],"modified_by":"\u3089\u304f\u308d\u3050","_links":{"self":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=71"}],"version-history":[{"count":2,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":859,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/859"}],"wp:attachment":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}