| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifing charts by user selection
Thanks Andy that seemd to do the trick.
Dan Thompson. "Andy Pope" wrote: Hi, Try this, Sub x() With ActiveChart.Parent MsgBox .Name & " Index " & .Index End With End Sub Cheers Andy Dan Thompson wrote: Hi All, I have a spread sheet with several different chart objects within it. I would like to write a simple macro so that If I cick (select) any one of the charts with-in the current spread sheet I am viewing and than run my macro, a msgbox will pop up and give me the Name of the chart object and the index number of the chart object. Any help would be greatly appreciated Thanks, Dan Thompson. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifing Weeks in a Month. | Excel Discussion (Misc queries) | |||
| Identifing total hours as a whole number | New Users to Excel | |||
| Identifing smallest numbers | Excel Discussion (Misc queries) | |||
| Checking specific cell, and identifing how many rows in the sheet | Excel Programming | |||
| User selection | Excel Programming | |||
Hybrid Mode
