PDA

View Full Version : [SOLVED] Input Box text to display Asterisks (*)



malik641
09-24-2005, 11:39 AM
If I have an input box that prompts for a password, can I make the text to display asterisks similar to Password text boxes on websites do?

Or maybe I do this with a userform? :dunno


Thanks,

Bob Phillips
09-24-2005, 12:00 PM
Userform I am afraid.

.

Norie
09-24-2005, 12:03 PM
This can actually be done but requires using the Windows API.

I'll see if I can find any links, but I agree with xld that the userform is a better option.

malik641
09-24-2005, 12:27 PM
Sounds good. I just figured out how to do it with the userform (still new at that) :thumb

Norie, if you can please submit any links. Otherwise mark it solved. :thumb

Thanks!

Emily
09-24-2005, 08:55 PM
Please read Password Inputbox using class module from MrExcel

http://www.mrexcel.com/board2/viewtopic.php?t=16886&postdays=0&postorder=asc&start=0

Ivan F Moala
09-24-2005, 08:59 PM
2 methods to do this here

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

Norie
09-24-2005, 11:37 PM
Emily

That way of doing it looks even more complicated than using the Windows API.

And I'm used to using both class modules and the API.

Emily
09-25-2005, 02:38 AM
Emily

That way of doing it looks even more complicated than using the Windows API.


That's why worth to read :beerchug:

Norie
09-25-2005, 07:32 AM
Emily

I've taken a look at that and basically what it does is dynamically create a userform.

A good approach perhaps, but I think it could cause security issues to do with whether or not the VBA environment can be manipulated programmatically.

Ivan F Moala
09-26-2005, 01:45 AM
Emily

I've taken a look at that and basically what it does is dynamically create a userform.

A good approach perhaps, but I think it could cause security issues to do with whether or not the VBA environment can be manipulated programmatically.

Yes your right .... Juan posted that solution > 31 Jul 2002 13:46

sheeeng
09-26-2005, 02:38 AM
Please read Password Inputbox using class module from MrExcel

http://www.mrexcel.com/board2/viewtopic.php?t=16886&postdays=0&postorder=asc&start=0


Great, Emily! Thanks! Are you Hong Kong local?

Emily
09-26-2005, 03:35 AM
Great, Emily! Thanks! Are you Hong Kong local?

Yes