InputBox hiding password characters

[Russell_Leaves]

Hi

Using Excel 2007 and Windows 7.

Is it possible that when you write your password in an InputBox, that stars appear while writing it in the InputBox?

I haven't found a solution that works with 2007.

Thanks

 

[JoeMo]

Hi

Using Excel 2007 and Windows 7.

Is it possible that when you write your password in an InputBox, that stars appear while writing it in the InputBox?

I haven't found a solution that works with 2007.

Thanks

There's a rather lengthy procedure available in post #2 at this link:
*** mask password in inputbox-VBForums

 

[Russell_Leaves]

Hi JoeMo

Tried that. Had a sub or function defined error at the following line.

    lngModHwnd = GetModuleHandle(vbNullString)

Any idea what's happened and how to fix it?

Thanks

 

[JoeMo]

Hi JoeMo

Tried that. Had a sub or function defined error at the following line.

    lngModHwnd = GetModuleHandle(vbNullString)

Any idea what's happened and how to fix it?

Thanks

A guess would be you don't have the routine GetModuleHandle in your project.

 

[Russell_Leaves]

Hi JoeMo

So I need to do something else than just copying the code from post 2 in the link you gave?

Russell

 

[Rick Rothstein]

I think it might be easier to create a global variable, then create a UserForm with a TextBox and Button on it, set the TextBox's PasswordChar property to an asterisk and have the button assign the TextBox's Text to the global variable and have your main code pick up the Text from the global variable. And, of course, you main code would handle loading and unloading the UserForm.

 

[Michael M]

Personally, I think it would be far easier to insert a textBox in a user form

See here

Hiding Entries in an InputBox (Microsoft Excel)

 

[Michael M]

Aahh....the joys of slow internet....Too fast for me Rick...ray: