| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write a button to run macro on *ANY* chart area clicked.
How do I identify an object in a macro when I click on it? I want to operate
on the object and must have some recognizable identity to use in the macro because I want the macro to operate on any object (really a chart) that I click on. I know how to identify an arbitrary cell by clicking on it and how to use the identity to run in a visual basic macro. For example: co = ActiveCell.Offset(0, -1).Range("A1").Column ro = ActiveCell.Offset(0, -1).Range("A1").Row give me the cell identity of the cell that I click on -- (ro, co) being the cell that was clicked on. Is there some way to identify a "Chart Area" in such a manner? --LJM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro button gets bigger when clicked | Excel Discussion (Misc queries) | |||
| Change Macro button color after clicked | Excel Discussion (Misc queries) | |||
| why is the chart displayed only when the chart area is clicked on? | Charts and Charting in Excel | |||
| Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
| How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming | |||
Threaded Mode
