{"id":8693,"date":"2011-11-16T16:29:24","date_gmt":"2011-11-16T15:29:24","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=8693"},"modified":"2011-11-15T16:29:33","modified_gmt":"2011-11-15T15:29:33","slug":"vba-procedure-oproepen-met-variabele","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/vba-procedure-oproepen-met-variabele\/","title":{"rendered":"VBA procedure oproepen met variabele"},"content":{"rendered":"<p>V. Kan ik in VBA een procedure uitvoeren met als naam de inhoud van een variabele?<\/p>\n<p>A.Ja, met Application.Run. Bijvoorbeeld, in een formulier deze code:<\/p>\n<p>Sub demo()<br \/>\nMsgBox &#8220;demo&#8221;<br \/>\nEnd Sub<\/p>\n<p>En op een formulier een knop met deze\u00c2\u00a0code:<\/p>\n<p>Private Sub CommandButton1_Click()<br \/>\nDim namemacro As String<br \/>\nnamemacro =<br \/>\nInputBox(&#8220;Give the name of the Sub to execute&#8221;)<br \/>\nApplication.Run<br \/>\nnamemacro<br \/>\nEnd Sub<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik in VBA een procedure uitvoeren met als naam de inhoud van een variabele? A.Ja, met Application.Run. Bijvoorbeeld, in een formulier deze code: Sub demo() MsgBox &#8220;demo&#8221; End Sub En op een formulier een knop met deze\u00c2\u00a0code: Private Sub CommandButton1_Click() Dim namemacro As String namemacro = InputBox(&#8220;Give the<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":4,"footnotes":""},"categories":[18,79,10,8,246,5],"tags":[],"class_list":["post-8693","post","type-post","status-publish","format-standard","hentry","category-development","category-odisee","category-office","category-office-2007","category-office-2010","category-visual-basic"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 13:45:55","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/8693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=8693"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/8693\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=8693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=8693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=8693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}