Tooltip for Excel picture button

**asha3010** · 03-10-2010, 02:27 PM

Greetings,

I have assigned a macro to a picture button in XL 2007. Is it possible to have a tooltip via VBA for the button?

Thanks in advance
AGS

**JBeaucaire** · 03-10-2010, 05:33 PM

1) Press ALT-F8 to open the Macro List
2) Click once on your macro name
3) Click on the OPTIONS button
4) Use the Description box to create your tooltip.

**asha3010** · 03-11-2010, 04:12 AM

Thanks for the prompt response JB.

Here's what I would like - when I move the cursor over the picture button, I would like a brief description to appear like the way when we place the cursor over any of the icons in the XL ribbon.

I am not able to achieve this by adding a description. Any ideas?

Thanks again
AGS

**JBeaucaire** · 03-11-2010, 04:27 AM

Hmm, I don't have Excel 2007, but this appears to apply to 2003 and 2007.

Please Login or Register  to view this content.

(source)

**asha3010** · 03-11-2010, 04:43 AM

Thanks JB - I did try this code before but did not get it to work.

I have just found a source that seems to have a workaround

http://excel.tips.net/Pages/T003294_..._an_Image.html

I will test and post back.

Regards
AGS