{"id":5156,"date":"2016-02-25T09:27:20","date_gmt":"2016-02-25T00:27:20","guid":{"rendered":"http:\/\/excelwork.info\/excel\/?p=5156"},"modified":"2016-02-25T09:27:20","modified_gmt":"2016-02-25T00:27:20","slug":"doeventsfunction","status":"publish","type":"post","link":"https:\/\/excelwork.info\/excel\/doeventsfunction\/","title":{"rendered":"CPU \u306b\u5236\u5fa1\u3092\u79fb\u3059\uff08DoEvents \u95a2\u6570\uff09"},"content":{"rendered":"

DoEvents \u95a2\u6570<\/h2>\n
\n

DoEvents \u95a2\u6570<\/strong>\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001CPU \u306b\u5236\u5fa1\u3092\u79fb\u3057\u3001\u4ed6\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u5b9f\u884c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
\n

\u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

DoEvents<\/strong><\/p><\/div>\n<\/div>\n

\n

DoEvents \u95a2\u6570 \u4f7f\u7528\u4f8b<\/h2>\n
\n

\u30e6\u30fc\u30b6\u30fc\u30d5\u30a9\u30fc\u30e0<\/h3>\n

\u30e6\u30fc\u30b6\u30fc\u30d5\u30a9\u30fc\u30e0\u3092\u633f\u5165\u3057\uff08UserForm1\uff09\u3001\u30e9\u30d9\u30eb\uff08Label1\uff09\uff11\u3064\u3068\u30b3\u30de\u30f3\u30c9\u30dc\u30bf\u30f3\uff08CommandButton1\u3001CommandButton2\uff09\uff12\u3064\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n

\"DoEvents<\/a> <\/p>\n

\u30b5\u30f3\u30d7\u30ebVBA\u30bd\u30fc\u30b9<\/h3>\n
\r\n\u3000\r\nSub Sample_DoEvents()\r\n\r\n    UserForm1.Show\r\n\r\nEnd Sub\r\n\u3000\r\n  <\/pre>\n

\n
\r\n\u3000\r\n\r\nPrivate i As Long\r\nPrivate myTimer As Boolean\r\n\r\n'\u300cSTART\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u6642\u306e\u51e6\u7406\r\nPrivate Sub CommandButton1_Click()\r\n    \r\n    myTimer = True\r\n    Call Sample_Timer\r\n\r\nEnd Sub\r\n\r\n'\u300cSTOP\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u6642\u306e\u51e6\u7406\r\nPrivate Sub CommandButton2_Click()\r\n\r\n    myTimer = False\r\n\r\nEnd Sub\r\n\r\n'UserForm1 \u3092\u8868\u793a\u3057\u305f\u6642\u306e\u51e6\u7406\r\nPrivate Sub UserForm_Initialize()\r\n\r\n    'Label1 \u306b\u300c0 \u56de\u300d\u3092\u8868\u793a\r\n    UserForm1.Label1.Caption = \"0 \u56de\"\r\n\r\n    'CommandButton1 \u306b\u300cSTART\u300d\u3092\u8868\u793a\r\n    UserForm1.CommandButton1.Caption = \"START\"\r\n\r\n    'CommandButton2 \u306b\u300cSTOP\u300d\u3092\u8868\u793a\r\n    UserForm1.CommandButton2.Caption = \"STOP\"\r\n\r\nEnd Sub\r\n\r\n'Label1 \u306b \u56de\u6570\u3092\u8868\u793a\u3057\u307e\u3059\r\nSub Sample_Timer()\r\n\r\n    Do While myTimer = True\r\n        \r\n        i = i + 1\r\n        Label1.Caption = i & \" \u56de\"\r\n        DoEvents\r\n        \r\n    Loop\r\n    \r\nEnd Sub\r\n\u3000\r\n  <\/pre>\n
\n
\u5b9f\u884c\u7d50\u679c<\/h3>\n
\u300c\u6a19\u6e96\u30e2\u30b8\u30e5\u30fc\u30eb\u300d\u306e Sample_DoEvents<\/strong> \u3092\u5b9f\u884c<\/p>\n
\"DoEvents<\/a><\/p>\n
\u300cSTART\u300d\uff08CommandButton1\uff09\u3092\u30af\u30ea\u30c3\u30af\u3001\u305d\u306e\u5f8c\u300cSTOP\u300d\uff08CommandButton2\uff09\u3092\u30af\u30ea\u30c3\u30af<\/p>\n
\"DoEvents<\/a><\/p>\n

\n
\u4e0a\u8a18\u306e\u30b5\u30f3\u30d7\u30eb\u3067\u3001DoEvents<\/strong> \u306f\u3001\u5fc5\u305a\u6307\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u5916\u3059\u3068\u7121\u9650\u30eb\u30fc\u30d7\u306b\u5165\u3063\u3066\u3057\u307e\u3046\u306e\u3067\u3001\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<\/div>\n

\n","protected":false},"excerpt":{"rendered":"
DoEvents \u95a2\u6570 DoEvents \u95a2\u6570\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001CPU \u306b\u5236\u5fa1\u3092\u79fb\u3057 … <\/p>\n","protected":false},"author":1,"featured_media":5161,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"amp_status":"","spay_email":"","jetpack_publicize_message":""},"categories":[37],"tags":[819,63,38],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2016\/02\/doevents_userform.jpg?fit=309%2C163&ssl=1","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4Ye9i-1la","_links":{"self":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/5156"}],"collection":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/comments?post=5156"}],"version-history":[{"count":6,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/5156\/revisions"}],"predecessor-version":[{"id":5202,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/5156\/revisions\/5202"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media\/5161"}],"wp:attachment":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media?parent=5156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/categories?post=5156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/tags?post=5156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}