Mask an entry using InputBox function

  • Thread starter Thread starter Vasco
  • Start date Start date
V

Vasco

My first usage of this newsgroup!

I would like to introduce a password in an input box to be
runned in a macro - as part of a connection string - , to
access an external database.
For this purpose, i would like that the entry in the input
box would be not echoed or that would show with a "*" mask.

Does any one out there can help?

Thanks for reading it,

Vasco
 
My first usage of this newsgroup!

I would like to introduce a password in an input box to be
runned in a macro - as part of a connection string - , to
access an external database.
For this purpose, i would like that the entry in the input
box would be not echoed or that would show with a "*" mask.

Does any one out there can help?

Thanks for reading it,
Click to expand...

You can't do it through either of the Input Boxes avaliable to Excel.
You would need to create a UserForm, put a TextBox control on it, and
set the PasswordChar Property of that text box to hide the input.
 
You need to use a UserForm for this. Add a textbox. In
the properties window, change the textbox's PasswordChar
to say *

Patrick Molloy
Microsoft Excel MVP
 
As far as I know, you can't create a mask using an input
box. You'll have to create your own User Form that uses a
textbox control that has the PasswordChar property set to
something (astrisks works well most of the time).
 
Back
Top