Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() in A1 i have the text, "this is a test" i try to use this select case statement var1 = "test" sStr = Range("A1").Value Select Case sStr Case sStr Like "*" & var1 & "*" 'do something here the first case statement is skipped but if i break and hover the mouse over it, says it equals true. if i go to the immediate window and type ?sStr Like "*" & var1 & "*" TRUE it returns true. so why does it skip to the next select case statement? if it's the only select case statement, it exits the select case without doing anything. -- Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Select Case question | Excel Programming | |||
select case question | Excel Programming | |||
VBA select case question | Excel Discussion (Misc queries) | |||
Select Case Question | Excel Programming |