Enter a password -- how to achieve this?

M

Martin

I have create a button, after click this button, I want to :

appear a message box which needs you to enter a PASSWORD. If the password is
right, the computer will show you something, otherwise if the password is
wrong, ther computer will ignore you require.

That is , how to make this enter password ? I am not sure message box
can do this.


Thank you!
 
D

Dennis

Use InputBox instead of Msgbox and then check if the input matches your
password stored in a table I assume. Something like this

Dim strTemp as String
strTemp = InputBox("Enter Password","Enter Password")
if strTemp = DLookUp("Password","Password Table") Then
Msgbox "OK to continue"
Else
Msgbox "Invalid Password"
End if
 
Top