Mask an entry using InputBox function
On Wed, 23 Jul 2003 04:26:26 -0700, "Vasco" wrote:
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,
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.
---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *
|