IN THIS TASK
Summary
In Microsoft Excel, you can create a custom dialog box to prompt a user for information by using text boxes, buttons, or other dialog box controls. Typically, when you type text in a text box, the text appears as you type. However, you can use a property of the Microsoft Visual Basic for Applications (VBA) Edition User Form to create the effect of a hidden or "masked" text box. This can be useful for creating a password dialog box, where you do not want the text that is typed in a text box to be "visible". The following information describes how to create this effect.
back to the top
Create a Dialog Box
-
Start Excel.
-
Press Alt+F11 to start the Microsoft Visual Basic Editor.
-
On the Insert Menu, click User Form.
-
Using the Controls Toolbox, add a text box and a command button on to your user form.
-
In the Properties sheet, in the Objectlist, click TextBox1.
-
On the Alphabetic tab, click
PasswordChar. -
Type an asterisk (*).
-
In the Properties sheet, in the Objectlist, click UserForm1.
-
On the Run menu, click Run User Form.
When you type letters, the asterisk appears instead.
back to the top
Code Sample to Use Dialog Box
To retrieve the text string written to the text box, you can use the following sample code:
-
Double-click CommandButton1 on your user form.
-
Type the following code:
Private Sub CommandButton1_Click()
MsgBox Me.TextBox1
End Sub -
Click Save to save your project.
-
On the Run menu, click Run Sub/User Form.
Type a word in the text box, and then click the
Command button. The text that you typed appears in the message box.
back to the top