{"id":710,"date":"2008-09-25T20:16:51","date_gmt":"2008-09-25T19:16:51","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=710"},"modified":"2021-01-09T12:48:16","modified_gmt":"2021-01-09T11:48:16","slug":"parameters-van-excel-vba-functies-zichtbaar-maken-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/parameters-van-excel-vba-functies-zichtbaar-maken-in-excel\/","title":{"rendered":"Parameters van Excel VBA functies zichtbaar maken in Excel?"},"content":{"rendered":"<p>V. Ik heb een functie geschreven in Excel die parameters aanneemt, maar ik zie die parameters niet verschijnen als ik die functie<\/p>\n<p>A. Eenvoudig antwoord: het kan niet. Complex antwoord: het kan, maar het is ingewikkeld en niet gegarandeerd dat het werkt. Collega MVP Bill Manville antwoorde me in dat verband:<\/p>\n<p>&#8220;You can set up a description via Excel &gt; Tools &gt; Macro &gt; Macros &gt; UDFName (type in as it won&#8217;t be in the list) &gt; Options<br \/>\nor using Application.MacroOptions<\/p>\n<p>There is a way to get descriptions of the function and its arguments into the function wizard, using Application.ExecuteExcel4Macro &#8220;REGISTER(&#8230;..)&#8221;<br \/>\nIt&#8217;s a bit complicated to set up and has a limit of 255 characters on the total REGISTER function call string.<\/p>\n<p>Rob Bovey, Stephen Bullen and John Green&#8217;s <em>Professional Excel Development <\/em>contains the gory details.&#8221;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik heb een functie geschreven in Excel die parameters aanneemt, maar ik zie die parameters niet verschijnen als ik die functie A. Eenvoudig antwoord: het kan niet. Complex antwoord: het kan, maar het is ingewikkeld en niet gegarandeerd dat het werkt. Collega MVP Bill Manville antwoorde me in dat<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[79,10],"tags":[499],"class_list":["post-710","post","type-post","status-publish","format-standard","hentry","category-odisee","category-office","tag-vba"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 23:26:22","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\/710","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=710"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/710\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}