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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.