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: .
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
Next Lesson: Command Buttons in VBA for Excel