Mask InputBox entry

[Rob]

Excel 2000.

Is it possible to mask the entry in an InputBox? I have a InputBox that a
user enters a password and this in turn runs a routine, I would like to show
* astrics as opposed to what they actually type, is this possible?

Thanks, Robert

 

[Nigel]

You can specify a password mask for a TextBox, using the PasswordChar
method. eg

TextBox1.PasswordChar = "*"

or in the properties set the passwordchar to *

 

[Rob]

Nigel,

I'm I correct in thinking that TextBox would be added to a userform? Is
there a way to mask without a creating a userform.

Thanks, Rob

You can specify a password mask for a TextBox, using the PasswordChar
method. eg

TextBox1.PasswordChar = "*"

or in the properties set the passwordchar to *






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption

=---

 

[Harald Staff]

Hi Rob

No.
(- or possibly maybe with extensive Windows programming, if so it's far more
work and a more unstable result than if you just make a simple form.)

HTH. Best wishes Harald

 

[Nigel]

Rob,

Yes, it would require a userform. In my view the best method.

Cheers
Nigel

 

[Ivan F Moala]

There are a couple of ways to do this with an Inputbox.
Have a look here

http://www.xcelfiles.com/API_09.html

This particular method uses Subclassing but there is another method
which involves the use of system timer.
Otherwise use a Userform.

 

[Rob]

Ivan,

Just the job thanks and a really useful web site to visit, gained lots of
ideas.

Great stuff. Rob