Input Box in VBA shouldn't display the text

[Marsdon]

Hi All,

I would like in to know whether this is possible in VBA input box.

For eg Look at the below image

As I have entered in the Input Box as Marsdon


But here I dont want the Text to be displayed as what I typed. Instead it should be ******

Can this be Done ??

 

[Colin Legg]

The built-in VBA Input Box does not natively support masking.

You could write some very complicated code to achieve this with the input box, but a much better and simpler option would be to create a userform which looks just like the input box. The text entry area of the userform would be an ActiveX textbox control which has a PasswordChar property which you can set to *. It will then mask each character as you want.

 

[Marsdon]

Thanks Colin,
I would try to figure out And get back to you

 

[Debraj]

Just emphasizing Colin's post..

 

[Deepak]

Check this too!!

https://www.dropbox.com/s/t9r3r0w2b7ql52j/Draft (3) (1)_Password4.xlsm

http://forum.chandoo.org/threads/user-access.16146/#post-97832