Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case question
Excel XP & Win XP
I'm trying to write one line of a Select Case construct that encompasses either one of 2 values. Something like: Case 34 Or 116: Call DoThis This line does not do anything, no error, does not call DoThis, nothing. I could of course write this in 2 lines and that works perfectly. Can this be written in one line? Thanks for your time. Otto |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case question
On Feb 28, 12:19 pm, "Otto Moehrbach" wrote:
Excel XP & Win XP I'm trying to write one line of a Select Case construct that encompasses either one of 2 values. Something like: Case 34 Or 116: Call DoThis This line does not do anything, no error, does not call DoThis, nothing. I could of course write this in 2 lines and that works perfectly. Can this be written in one line? Thanks for your time. Otto You were close. Just change it to: Case 34, 116: Call DoThis HTH, Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case question
Thanks Mike. That makes things a lot simpler for me. Otto
"Mike Woodhouse" wrote in message oups.com... On Feb 28, 12:19 pm, "Otto Moehrbach" wrote: Excel XP & Win XP I'm trying to write one line of a Select Case construct that encompasses either one of 2 values. Something like: Case 34 Or 116: Call DoThis This line does not do anything, no error, does not call DoThis, nothing. I could of course write this in 2 lines and that works perfectly. Can this be written in one line? Thanks for your time. Otto You were close. Just change it to: Case 34, 116: Call DoThis HTH, Mike |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case question
Excel XP & Win XP
I'm trying to write one line of a Select Case construct that encompasses either one of 2 values. Something like: Case 34 Or 116: Call DoThis This line does not do anything, no error, does not call DoThis, nothing. I could of course write this in 2 lines and that works perfectly. Can this be written in one line? Thanks for your time. Otto Separate them with commas, instead of OR: Case 34, 116: Call DoThis |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case question
I like to include "is":
Case is = 34, 116: Call DoThis Case Is 123, Is < 155: Call DoThat Otto Moehrbach wrote: Excel XP & Win XP I'm trying to write one line of a Select Case construct that encompasses either one of 2 values. Something like: Case 34 Or 116: Call DoThis This line does not do anything, no error, does not call DoThis, nothing. I could of course write this in 2 lines and that works perfectly. Can this be written in one line? Thanks for your time. Otto -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case question
Thanks Dave. I'll do that too. Otto
"Dave Peterson" wrote in message ... I like to include "is": Case is = 34, 116: Call DoThis Case Is 123, Is < 155: Call DoThat Otto Moehrbach wrote: Excel XP & Win XP I'm trying to write one line of a Select Case construct that encompasses either one of 2 values. Something like: Case 34 Or 116: Call DoThis This line does not do anything, no error, does not call DoThis, nothing. I could of course write this in 2 lines and that works perfectly. Can this be written in one line? Thanks for your time. Otto -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
select case question | Excel Programming | |||
VBA select case question | Excel Discussion (Misc queries) | |||
Select Case Question | Excel Programming |