Entering Passwords (VBA / Excel 2000 / SP3)

Topic

New Reply

I am using the Inputbox to accept a password from the user. Does anyone have a snippet of code to mask the input; or another method of accepting input that doesn’t expose the response?

Reply | Quote

Replies

If this is for a workbook or worksheet, can you use the:

Application.Dialogs(xlDialog…).Show

Method with xlDialogWorkbookProtect or xlDialogProtectDocument arguments?

Reply | Quote

John
Thanks for the response. The password is being used to allow the VBA procedure to continue. But fear not; your post was enlightening.

Reply | Quote

John
Thanks for the response. The password is being used to allow the VBA procedure to continue. But fear not; your post was enlightening.

Reply | Quote

If this is for a workbook or worksheet, can you use the:

Application.Dialogs(xlDialog…).Show

Method with xlDialogWorkbookProtect or xlDialogProtectDocument arguments?

Reply | Quote

You can build a simple enough userform to achieve what you want. The standard TextBox available for userforms has a PasswordChar property which can be set to an asterisk or any other suitable character.

Sample attached.

Andrew C

Reply | Quote

Andrew
Thank you. That is exactly what I want.

Reply | Quote

Andrew
Thank you. That is exactly what I want.

Reply | Quote

You can build a simple enough userform to achieve what you want. The standard TextBox available for userforms has a PasswordChar property which can be set to an asterisk or any other suitable character.

Sample attached.

Andrew C

Reply | Quote