Forum

VBA form Password p...
 
Notifications
Clear all

VBA form Password protect

2 Posts
2 Users
0 Reactions
85 Views
(@stevenbehr1)
Posts: 92
Estimable Member
Topic starter
 

Hi,

 

Im wondering, I understand password protections with sheets in VBA.

But I cant seem to understand if there is a VBA FORM password protection.  So when a person opens a form that have to use a password to access that form.

 

If someone can give an example or link that would be great

 

Steve

 
Posted : 17/03/2020 1:20 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Steven,

You don't need a form password to do that, there is no such thing.

Collect user password with a text inputbox, check it, and if it's correct, display the form:

Pass=Inputbox("Type your password")

If Pass = "MyPassword" Then

userForm1.Show

Else

msgbox "Wrong password!"

End if

 
Posted : 17/03/2020 2:52 am
Share: