|
Validation/Macros
Hi Jock
Sub test() On Error Resume Next Sheets(ActiveSheet.Range("A1").Value).Select On Error GoTo 0 End Sub With the data validation list in A1 try this -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "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... |
Validation/Macros
Oops, I forgot to tell you that you must run this macro in the Change event.
See Tom's reply -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Jock Sub test() On Error Resume Next Sheets(ActiveSheet.Range("A1").Value).Select On Error GoTo 0 End Sub With the data validation list in A1 try this -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "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... |
| All times are GMT +1. The time now is 07:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com