Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation/Macros
Thanks Tom...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros running with Validation Rules | Excel Worksheet Functions | |||
Excel 2007-programming macros that apply to data validation | New Users to Excel | |||
Macros & Validation | New Users to Excel | |||
Data Validation & Macros | Excel Discussion (Misc queries) | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |