MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

combo box/list box/checkbox Tool Tip

  Asked By: Gin    Date: Dec 14    Category: MS Office    Views: 1725

If i have names of very long lenth in combo box,i need to have a
tool tip which shows the name of that,when mouse is pinted on that perticular
text.i dont see any tooltiptext function for combobox in in Excel VBA.could any
one help me out to replicate this.



3 Answers Found

Answer #1    Answered By: Jarryd Williams     Answered On: Dec 14

If excel  doesn't provide what you want, then you might be out of luck.
AFAIK there is no user-accessible hover event in Excel.

I'm not sure how a tooltip would work for the contents of a combo  box
anyway. If you hovered over it, it would not know which data row to

It is possible to trap the mouse  movement/position event and you could do
something with that - with significant effort. A Google search for "excel
hover event" found at least one hit for someone trying to do this.

Answer #2    Answered By: Kate Johnston     Answered On: Dec 14

I don't think you can get the tool  tip to change as you
"hover" over an entry. You'll have to actually select it.
then you can use the value to change the ControlTitText property.

Answer #3    Answered By: Gavril Bonkob     Answered On: Dec 14

Thanks for the response.i'll check with the ControlTitText
property.But in my excel  user wants to see the the name in comobobox and then
select it.He is not able to see the total name as it is longer than
combobox,hence he is expecting Tool tip.

Didn't find what you were looking for? Find more on combo box/list box/checkbox Tool Tip Or get search suggestion and latest updates.