{"id":17232,"date":"2021-11-14T10:46:30","date_gmt":"2021-11-14T09:46:30","guid":{"rendered":"https:\/\/ekiwi-blog.de\/?p=17232"},"modified":"2021-11-14T10:53:02","modified_gmt":"2021-11-14T09:53:02","slug":"vba-button-change-font-size","status":"publish","type":"post","link":"https:\/\/ekiwi-blog.de\/en\/17232\/vba-button-change-font-size\/","title":{"rendered":"VBA: button change font size"},"content":{"rendered":"

With VBA<\/abbr> many things can be automated under Microsoft Office<\/em> applications. Among other things, forms can be created with the Visual Basic Editor<\/em>, with which you can query and process user interactions. Such UserForms<\/a> always need at least one button (CommandButton) to trigger an action or event. Sometimes you have to adjust the font size of the button (CommandButton)<\/strong> for space or design reasons.<\/p>\n

\"Screenshot<\/a>
Using different font sizes on VBA button<\/figcaption><\/figure>\n

Unfortunately, this is not immediately obvious in the Visual Basic Editor, since you cannot find the property “FontSize<\/em>” in the Properties-Window. Instead you have to go to the property “Font<\/em>” in the properties-window and click on the button with the three dots “…”<\/strong>.<\/p>\n

If the properties window is not displayed, you can display it by pressing the F4 key<\/em> or selecting View => Properties Window<\/em>.<\/p>\n

\"Screenshot<\/a>
Click the button with three dots at the “Font” property<\/figcaption><\/figure>\n

Now you get a dialog for the font, under which you can set all the properties of a font, including the font size (Size).<\/p>\n

\"VBA<\/a>
Set font size in the font dialog<\/figcaption><\/figure>\n

Thus it is possible to change the font size<\/a> of the CommandButton but also generally the font size in the VBA form.<\/p>","protected":false},"excerpt":{"rendered":"

This article shows how to change font size of a button (CommandButton) in a VBA form. This can be done via the properties window.<\/p>\n","protected":false},"author":2,"featured_media":13630,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1555],"tags":[1701,1702,1704,1327,1858,1860,1700,1861,1705,1862,1706,1710],"class_list":["post-17232","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-en","tag-access-en","tag-excel-en","tag-microsoft-office-en","tag-microsoft-office","tag-microsoft-office-en-2","tag-programmierung-en","tag-programming","tag-vba-en-2","tag-vba-en","tag-visual-basic-for-application-en-2","tag-visual-basic-for-application-en","tag-word-en"],"_links":{"self":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/17232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/comments?post=17232"}],"version-history":[{"count":0,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/17232\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media\/13630"}],"wp:attachment":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media?parent=17232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/categories?post=17232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/tags?post=17232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}