Thread: How do you say "If, Or, Then, Else" in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Newbie1[_2_] Newbie1[_2_] is offline
external usenet poster
  
Posts: 2
Default How do you say "If, Or, Then, Else" in VBA
Happy Easter everyone

I have a working If statement

Private Sub CommandButton1_Click()
If MyPassword.TextBox1.Value = "kenny" Then
Unload MyPassword
Else
MsgBox "Password incorrect - access denied!"
End If
End Sub

I want to allow two values so I tried changing the first line to -

If MyPassword.TextBox1.Value = "kenny" Or "kenny1" Then

But that did not work!

Could someone assist please

Kenny
Windows Me and 2000
Office 97 and 2000



Reply With QuoteReply With Quote