{"width":"100%","categories":["ExcelVBA"],"title":"ExcelVBA\u3067\u5165\u529b\u3059\u308b\u3068\u304d\u4ed8\u7b8b\u7684\u306a\u3082\u306e\u3092\u51fa\u3059","blog_url":"https://blog.systemjp.net/","image_url":null,"provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.systemjp.net%2Fentry%2F2020%2F09%2F14%2F132558\" title=\"ExcelVBA\u3067\u5165\u529b\u3059\u308b\u3068\u304d\u4ed8\u7b8b\u7684\u306a\u3082\u306e\u3092\u51fa\u3059 - shikaku&#39;s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","height":"190","published":"2020-09-14 13:25:58","blog_title":"shikaku's blog","url":"https://blog.systemjp.net/entry/2020/09/14/132558","author_url":"https://blog.hatena.ne.jp/shikaku/","description":"\u5165\u529b\u898f\u5247\u3092\u4f7f\u3046 With Range(\"B2\").Validation '\u5165\u529b\u898f\u5247\u3092\u524a\u9664 .Delete '\u5165\u529b\u898f\u5247\u306e\u8a2d\u5b9a '\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u30b9\u30bf\u30a4\u30eb\u306f\u300c\u505c\u6b62\u300d .Add Type:=xlValidateDate, _ Formula1:=\"2015/1/1\", _ Operator:=xlLessEqual, _ AlertStyle:=xlValidAlertStop .InputTitle = \"\u65e5\u4ed8\u5165\u529b\" .InputMessage = \"\u4eca\u65e5\u3088\u308a\u524d\u306e\u65e5\u4ed8\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\uff01\" .ShowInput = True End With \u30cd\u30bf\u5143 https://excelwork.info\u2026","type":"rich","author_name":"shikaku","version":"1.0"}