Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case issue
Hi, I am having a problem with the code below. 'Update' is pased to the macro
as a string and can only = one of the items below, but the Case Select does not match it to any of them. Select Case Update Case "Finances" Finances_Updater UpdateToolName, mybook Case "Hierarchy" Hierarchy_Updater UpdateToolName, mybook Case "Both" Hierarchy_Updater UpdateToolName, mybook Finances_Updater UpdateToolName, mybook End Select thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case issue
The first step you should do is make sure the String value you are passing
in is exactly what you think it is. Put a break point on the Select Case Update statement and then execute this statement in the immediate window... Print "<" & Update & "" Then check to see if the angle brackets butt-up against the word or if there are "extra" characters (perhaps spaces) attached to the word. Also, the Case tests will be case-sensitive, so does the word with an upper case letter and are the rest of the letters lower case? Rick "Whit" wrote in message ... Hi, I am having a problem with the code below. 'Update' is pased to the macro as a string and can only = one of the items below, but the Case Select does not match it to any of them. Select Case Update Case "Finances" Finances_Updater UpdateToolName, mybook Case "Hierarchy" Hierarchy_Updater UpdateToolName, mybook Case "Both" Hierarchy_Updater UpdateToolName, mybook Finances_Updater UpdateToolName, mybook End Select thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Variable Case issue | Excel Programming | |||
End Select without Select Case, Block If without End If errors | Excel Programming | |||
Select Case - issue | Excel Discussion (Misc queries) |