Guidance required please...
Hi Claus
Thx for your reply
the code hangs on this line:
Application.Goto Sheets(.Value).Range("A1")
I appreciate your efforts, though it isn't quite what I was looking for as I
don't need the focus changed to the destination sheet once the user selects
a value from the dropdown....
Once he/she has filled in all the other relavent cells, then they hit a
CmdBtn Then I would like it to select the appropriate Sheet based on said
Value, then do it's thing.
As I stated, I have it working very well already in another workbook,
although that is triggered by a standard cell, not a dropdown..
Thx again
Mick.
|