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.
|