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

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! *

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

-----Original Message-----
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


.

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).

-----Original Message-----
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


.