What's this Tooltip Control? Can I programmatically write text to

[Peter]

http://xs202.xs.to/xs202/06241/ToolTips.JPG

Thanks,

 

[Chip Pearson]

Which Office program are you asking about?

 

[Andy Pope]

Hi,

Looks like the Input message from Data validation.

Menu Data > Validation... > Input Message.

Cheers
Andy

 

[Helmut Weber]

Hi Peter,

to me it looks like a comment attached to an Excel cell.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Helmut Weber]

Range("C5").Comment.Text _
Text:="State" & Chr(10) & "How are you doing"

HTH

 

[Peter]

Hi Chip,

I'm using Excel 2003

Thanks,

Which Office program are you asking about?

 

[Peter]

Hi Andy,

I can't find the command in ur suggested step...

Thanks,

 

[Peter]

Hi Helmut,

I also though it's a Comment initially, but I found no 'red arrow' located
at the top right hand corner in fact. Also, I can't "Edit Comment" by right
clicking on this cell.

Thanks,

 

[Andy Pope]

See Debra's explanation of Data validation
http://www.contextures.com/xlDataVal01.html

and specifically
http://www.contextures.com/xlDataVal04.html

Cheers
Andy

 

[Peter]

Hi Andy,

Thanks for your info, but my point in this thread is not validation, but I
don't know what's the descriptive tooltip control in fact.

Thanks,

 

[rob byrne]

When I move my mouse over a datapoint on an Excel chart a yellow box pops up
containing the series name and datapoints values. What is the VBA name of
this object and can I change it from the default value?
I am new to this and am unsure of what to search for.
Thanks
RB

 

[Andy Pope]

Hi,

There is no simple way to do this. You will need to program against the
chartevents.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

If you just want the functionality try Tushar's free addin.
http://tushar-mehta.com/excel/software/chart_hover_label/index.html

Cheers
Andy

 

[rob byrne]

I am pleased to know there is no simple way of doing it.
Thanks very Much
Andy