Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro selecting datalabel
Hi.
I am trying to write a macro that selects text inside a datalabel, because I would then like to copy it to a cell, so that I can work with it. Does anybody know how to do this? Thanks in advance Jerry. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro selecting datalabel
Jerry
Like this? Range("a1").Value = Sheet1.Label1.Caption -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Jerry Koch" wrote in message ... Hi. I am trying to write a macro that selects text inside a datalabel, because I would then like to copy it to a cell, so that I can work with it. Does anybody know how to do this? Thanks in advance Jerry. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003) | Charts and Charting in Excel | |||
DataLabel Overlap | Charts and Charting in Excel | |||
datalabel box is too small | Charts and Charting in Excel | |||
Conditional Datalabel formating | Charts and Charting in Excel | |||
How to positionne DataLabel on top of a point ? | Charts and Charting in Excel |