Excel VBATutorial                      

             

Excel VBA Macros

Email to excel-vba.com

Excel Tutorial on Macros

 Excel Consulting

Here is a sample of what you will find in lesson 27 of the downloadable Tutorial on Excel macros

Lesson 27 on Excel macros (VBA):

Text Boxes in VBA for Excel

In the toolbox the text box icon is:  VBA for Excel text boxes.

The text box is the simplest control that requires an entry by the user. The user types something in it and this value can then be used in your VBA procedure. You will usually add a label to accompany the text box.

For most controls including the VBA for Excel text box there are general properties that allow you to set the font, the color of the font, the color of the background, the type of background, the type of border and other design features.

As its name says it the text box carries text. To use the contents of a text box as a number, to add dollar signs, decimal and other numerical features see the downloadable tutorial on Excel macros (VBA).

Adding a Text Box to a Userform

To add a text box to a userform you left click on its icon in the toolbox. You move the cursor to the userform, you click again and the text box appears. You can then resize it to your liking.  If you double click on the text box icon in the toolbox you can then click on the form as many times as you need text boxes. When you are finished adding text boxes just click once on the text box icon of the toolbox.


We hope you have enjoyed this introduction to lesson 27
for more on this topic and a complete course on Excel macros download the
Tutorial on Excel Macros


Next Lesson: Command Buttons  in VBA for Excel