Password * from macro

[ChemistB]

I have a macro which had

Please Login or Register  to view this content.

I want to be able to see only **** when entering the password. Looking around this forum, I've figured out that I need to use a user form instead of input box. (Yes?)

I have very little experience with Userforms. I created a user form (userform1) with a single text box (textbox1) with the properties of the text box saying passwordchar =* and a command button that I intend to use to close the userform.

How to I call that Userform from within the macro and set the textbox value equal to PWORD?

Please Login or Register  to view this content.

or do I set PWORD = TextBox1.Value from the command button on the userform?

Please Login or Register  to view this content.

I Dimensioned PWORD within the macro, do I need to dimension it elsewhere?

Thanks in advance!

[Ceeseven]

in macro to open userform for password

Please Login or Register  to view this content.

i believe password needs to be set as string. rest of code depends on your need

Please Login or Register  to view this content.

command to close

Please Login or Register  to view this content.

i am new. hope this helps.

[VBA Noob]

These links may be of interest

http://www.xcelfiles.com/API_09.html
http://www.bygsoftware.com/examples/...s/password.zip

VBA Noob

[royUK]

Set the TextBox's passwordChar to *.

In the VB Editor click on the TextBox then scroll down the TextBox properties to find the property.

Here's a couple of examples

http://www.sendspace.com/file/pryask
http://www.sendspace.com/file/s3rrnj