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.

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.