Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I want to be able to navigate around my sheet by running macro's when certain cells are selected. I have the following code; Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Not Intersect(Target, Range("A49")) Is Nothing Then showcalendar End Sub which works fine, however I have tried numerous ways to have this code operate based on different cells. Eg. I also want to run a macro when cell AF95 is selected and a different macro when cell A53 is selected. I cannot find a way to use this code more than once. Any help is appreciated. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running a macro from currently selected cell? | Excel Discussion (Misc queries) | |||
specify cell selection in a marco | Excel Discussion (Misc queries) | |||
Running a macro in a selected cell... | Excel Discussion (Misc queries) | |||
Running code on a drop down selection change | Excel Worksheet Functions | |||
Saving copied info while running a Selection Change Macro | Excel Programming |