passwords as * instead of characters

[flaviooooo]

Hi,
this problem is located in Excel 97.

I have an inputbox where i want to ask for a password etc. but i'd like to have the password-entry seen as **** instead of characters. I hope you understand what i mean...

Thanks

 

[xlbo]

Can't be done in aninputbox - use a userform with a textbox and commandbutton
Set the textbox passwordchar property to * and on your commandbutton, some code like:
Activesheet.protect password:=frmName.textboxName.text Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[flaviooooo]

ok, thanks
but another stupid question...

how do i add a userform in excel??

 

[xlbo]

Go to the VBE and make sure your workbook is the current project then just goto
Insert>Userform Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde