Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pop up a Macro when the cell in one column is selected-urge
I know how to call a Macro when one cell is selected as below. But this only
works when cell B1 is selected. But anybody knows how to trigger the macro when any cell in one column is selected (E.g when cell from B1 to B1000 is selected...) Thanks a lot! +++++++++++++++++++++++++++++++++++++++++++++ Private Sub Worksheet_Selectionchange(ByVal Target As Range) If Target.Address = "$B$1" Then Call OpenCalendar End If End Sub +++++++++++++++++++++++++++++++++++++++++++++ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How I can change the direction of Paste All in MS-Excel (MOST URGE | New Users to Excel | |||
Macro, Copy Selected Cells Down a Column | Excel Discussion (Misc queries) | |||
Macro to take selected cells times a selected cell | Excel Programming | |||
How to record macro to work on selected column/row? | Excel Programming | |||
Macro to move selected cell contents to a specific column on same row | Excel Programming |