Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there anyway to set up this code to use OR for a case statement or
a way to check multiple things without putting in another case is =? the code below is a general idea of what I am trying to do. Thanks, Jay E: Select Case Range("A1") .value Case is = "Jim" or "Bill" Drk = 1 Case is = "Jill" or "Fred" Drk = 2 case else range("A`1")=Inputbox("this is not a valid name, please enter a valid name and press enter.") goto E End Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select Case Statement | Excel Worksheet Functions | |||
import external data sql case statement | Excel Discussion (Misc queries) | |||
IF STATMENT OR CASE STATEMENT | Excel Discussion (Misc queries) | |||
Anyone actually get Case statement to work ... ? | Excel Worksheet Functions | |||
CASE statement equivalent | Excel Worksheet Functions |