View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Hank Scorpio Hank Scorpio is offline
external usenet poster
 
Posts: 103
Default 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! *