Msg/Input Box Password Char

Topic

New Reply

Hello all,

Is it possible to set a password character for an input box or msg box instead of using a form?

I am using Excel 2000/Win98SE

Thanks,
Mike

Reply | Quote

Replies

As far as I know, this is not possible. But, of course, you can make a form, which resembles very much the inputbox dialog box and add the following code in the initialize event of the userform:

Private Sub UserForm_Initialize()
TextBox1.PasswordChar = “*”
End Sub

where the textbox replaces the actual inputbox.

Reply | Quote