{"id":17100,"date":"2021-11-01T21:21:39","date_gmt":"2021-11-01T20:21:39","guid":{"rendered":"https:\/\/ekiwi-blog.de\/?p=17100"},"modified":"2022-05-25T12:24:34","modified_gmt":"2022-05-25T11:24:34","slug":"vba-multiline-textbox","status":"publish","type":"post","link":"https:\/\/ekiwi-blog.de\/en\/17100\/vba-multiline-textbox\/","title":{"rendered":"VBA: Multiline Textbox"},"content":{"rendered":"

If you work a lot with Microsoft Office<\/em>, you can use VBA<\/abbr> to make many tasks easier. Sometimes you need to fetch the content of a website<\/a> and sometimes you need a multiline textbox<\/strong> in a VBA form (UserForm) to enter user data.<\/p>\n

\"Screenshot<\/a>
Example of a textbox with line break<\/figcaption><\/figure>\n

The example here shows a userform<\/a> with a textbox that automatically wraps when the text exceeds the width of the text box.<\/p>\n

This is achieved by setting the Multiline Property to True<\/strong>.<\/p>\n

\"Screenshot<\/a>
Set Multiline property to True<\/figcaption><\/figure>\n

Enter does not work with multiline textbox<\/h2>\n

The problem is that this only happens automatically. You can’t use the Enter<\/a> or Return key to force the line break when writing. As it is shown in the following example picture, it does not work for the time being.<\/p>\n

\"Screenshot<\/a>
Line breaks created with Enter\/Return key<\/figcaption><\/figure>\n

To do this, we need to adjust another property of the text box. As shown in the image below, we need to set the EnterKeyBehavior property to True<\/strong>.<\/p>\n

\"Screenshot<\/a>
Set property EnterKeyBehavior to True<\/figcaption><\/figure>\n

In combination with Multiline True you can insert line breaks as shown above.<\/p>\n

More detailed explanations of the Multiline Property can be found on the Microsoft website<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"

If you work a lot with Microsoft Office, you can use VBA to make many tasks easier. Sometimes you need<\/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,1703,1858,1704,1860,1700,1705,1861,1706,1862],"class_list":["post-17100","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-en","tag-access-en","tag-excel-en","tag-microsoft-en","tag-microsoft-office-en-2","tag-microsoft-office-en","tag-programmierung-en","tag-programming","tag-vba-en","tag-vba-en-2","tag-visual-basic-for-application-en","tag-visual-basic-for-application-en-2"],"_links":{"self":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/17100","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=17100"}],"version-history":[{"count":0,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/17100\/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=17100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/categories?post=17100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/tags?post=17100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}