Posted to microsoft.public.excel.programming

Alan Beban[_2_] Alan Beban[_2_] is offline

external usenet poster

Posts: 783

Select Case

Jon Peltier wrote:
Alan -

I always do it this way:

Sub abtest4()
Dim x
x = 4
Select Case x
Case 2, 4
MsgBox x
End Select
End Sub

Thanks.

Alan Beban

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
Case without Select Case error problem	Ayo	Excel Discussion (Misc queries)	2	May 16th 08 03:48 PM
how to use select case	Junior728	Excel Programming	5	May 15th 07 10:17 AM
End Select without Select Case, Block If without End If errors	Atreides	Excel Programming	12	November 17th 06 05:10 PM
Select Case	achidsey	Excel Programming	4	September 18th 05 05:24 PM

All times are GMT +1. The time now is 09:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us