Validation/Macros
in in Excel 2000 or later, right click on the sheet tab (of the sheet or
sheets where you want this behavior) and select view code.
in the module that results, in the upper left corner select worksheet from
the dropdown. In the upper right corner, select Change from the dropdown.
you will get a code declaration like
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
(make sure you use the Change rather than SelectionChange code
declaration).
Assume the cell with the validation is cell D9
Private Sub Worksheet_Change(ByVal Target As Range)
if Target.Address = "$D$9" then
Worksheets(Target.Value).Activate
End if
End Sub
This assumes the name in the cell matches the name of the sheet.
--
Regards,
Tom Ogilvy
"Jock" wrote in message
...
Hi...
Eek someone help me!
I have 12 sheets one for each month and on each a validation drop down
menu with the list ofm months. Has anyone got any code to help me so that
when I the cell is activayed by the validation value the sheet can change to
the correct month...
A beer in the mail to anyone who can help me out...I know its easy...but
not for a novice like me...
Jock...
|