Cover up password InputBox

[photon_ed]

Hello,

I will need to have a inputbox for passwords, however i would like it to be covered up with stars. i.e. for the password "IneEdAbReAk", this will display in inbox as *********** as you are typing it in.
I will be grateful someone can give me some advice, Thank you.

yours,
Ed

[lucas]

If the input box is on a form as a textbox you just open the properties window for the textbox and look for passwordchar put an * there....

[Emily]

InputBox password character , Ivan F Moala

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

[Emily]

Password Inputbox (Class method) from Mr Excel

http://www.mrexcel.com/archive2/15000/16886.htm

[photon_ed]

Thanks for the prompt replies. I was hoping that it will be adding something simple after the codes below.

Password = Application.InputBox("Please Enter Your Password", 2)

Please advise. Thank you.

yours,
Ed

[debauch]

You do not need to code to do this. It is in the properties for the inputbox.

[photon_ed]

apologise for being dumb but how do I open properties window for the textbox? please advise. Thanks

yours,
Ed

[lucas]

Is the textbox on a sheet or a form?

[debauch]

My apologizes. I was thinking a 'textbox' rather than an input box. A textbox would physically be on a sheet or a form, and you can edit the properites. But with an input box, I am not sure the code to change its properties as you cannot edit the inputbox in design mode.

[photon_ed]

Thanks for the prompt replies.
It will be off a module vba code which creates a popup input box. see code below and please advise. Thank you.
Yours,
Ed

Password = Application.InputBox("Please Enter Your Password", 2)

[lucas]

From a search of the forum:
http://www.vbaexpress.com/forum/showthread.php?t=5346&highlight=inputbox+password

[lucas]

Looks like it would be much easier to use a small userform.......with a textbox...

[photon_ed]

Thanks Lucas,

It looks way too complicated for what i am tryin to do, i might leave it for now. However, Thank you so much for all the replies :)

yours,
Ed

[lucas]

A userform with textbox is fairly easy, give me a few minutes and I will post you an example....

[Norie]

Ed

The only way you will be able to do this is either with the code from the links Emily posted or with a userform as suggested by Steve.

[lucas]

Look this one over by Justin from a previous post on the subject. It is not set up to hide sheeets ect....will leave that to you. This one only unprotects the sheet if you put in the correct password.

Trying to give you a simple example to build on

[photon_ed]

Thank you Lucas, i will have a go at it.
All helps are very much appreciated, Many thanks!

yours,
Ed