| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identify selected chart
Hello Group,
I have two charts on Sheet1. One of them is selected. How do I determine which has been selected ? VBA Thanks, Michael Singmin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identify selected chart
Hi Michael
you can use the activechart.name syntax e.g. MsgBox ActiveChart.Name Cheers JulieD "Michael Singmin" wrote in message ... Hello Group, I have two charts on Sheet1. One of them is selected. How do I determine which has been selected ? VBA Thanks, Michael Singmin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identify selected chart
msgbox activechart.name
-- Don Guillett SalesAid Software "Michael Singmin" wrote in message ... Hello Group, I have two charts on Sheet1. One of them is selected. How do I determine which has been selected ? VBA Thanks, Michael Singmin |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identify selected chart
Hi,
If you don't want to deal with the sheetname information returned by Activechart.Name then you can use Msgbox Activechart.parent.name Cheers Andy Michael Singmin wrote: Hello Group, I have two charts on Sheet1. One of them is selected. How do I determine which has been selected ? VBA Thanks, Michael Singmin -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you select a chart but not see it's selected? | Charts and Charting in Excel | |||
| Determining if a chart is selected | Charts and Charting in Excel | |||
| Need to identify object selected. | Excel Programming | |||
| Identify User Selected Range | Excel Programming | |||
| Identify Range Selected By User | Excel Programming | |||
Hybrid Mode
