Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.



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

  1. Start Excel.

  2. Press Alt+F11 to start the Microsoft Visual Basic Editor.

  3. On the Insert Menu, click User Form.

  4. Using the Controls Toolbox, add a text box and a command button on to your user form.

  5. In the Properties sheet, in the Objectlist, click TextBox1.

  6. On the Alphabetic tab, click

  7. Type an asterisk (*).

  8. In the Properties sheet, in the Objectlist, click UserForm1.

  9. 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:

  1. Double-click CommandButton1 on your user form.

  2. Type the following code:

    Private Sub CommandButton1_Click()
    MsgBox Me.TextBox1
    End Sub
  3. Click Save to save your project.

  4. 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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!