Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you say "If, Or, Then, Else" in VBA
Hi
try If MyPassword.TextBox1.Value = "kenny" Or _ MyPassword.TextBox1.Value = "kenny1" Then -- Regards Frank Kabel Frankfurt, Germany Newbie1 wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you say "If, Or, Then, Else" in VBA
Classic case for a With
Private Sub CommandButton1_Click() With MyPassword.TextBox1 If .Value = "kenny" Or .Value = "kenny1" Then Unload MyPassword Else MsgBox "Password incorrect - access denied!" End If End With End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try If MyPassword.TextBox1.Value = "kenny" Or _ MyPassword.TextBox1.Value = "kenny1" Then -- Regards Frank Kabel Frankfurt, Germany Newbie1 wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you say "If, Or, Then, Else" in VBA
You may want to take a look at: "Select case" in VBA's help
Select Case LCase(myPassword.TextBox1.Value) Case Is = "kenny", "kenny2" 'do lots of stuff Case Is = "jimmy" 'do different stuff Case Else MsgBox "no, no!" End Select Newbie1 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |