How do you say "If, Or, Then, Else" in VBA

Posted to microsoft.public.excel.programming

Newbie1[_2_] Newbie1[_2_] is offline

external usenet poster

Posts: 2

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell	Steve Kay	Excel Discussion (Misc queries)	2	August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock"	inthestands	Excel Worksheet Functions	2	July 19th 07 07:05 PM
HELP on "left","right","find","len","substitute" functions	serene83	Excel Discussion (Misc queries)	5	June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next	BCB	New Users to Excel	7	May 13th 06 10:02 PM
Insert "-" in text "1234567890" to have a output like this"123-456-7890"	Alwyn	Excel Discussion (Misc queries)	3	October 25th 05 11:36 PM

All times are GMT +1. The time now is 11:18 AM.

Menu

About Us