Danny,

I posted some code some time back to add tooltips to ACtiveX controls. You
should be able to adapt it to shapes

You can find it on Google at http://tinyurl.com/kktm


--

HTH

Bob Phillips

"Danny Sowden" wrote in message
...
I have built a spreadsheet where by when the user clicks
on a picture a macro runs which displays some data. Is
there any way I can get the picture to have some Control
Tip Text on it when the user puts the mouse over it? I
want this to work in a similar way to the Alt tags on
pictures on websites. Can i do this within the Macro, my
current macro code is -

Sub Picture98_Click()
UserForm1.ListBox1.RowSource = "203!S1:T23"
UserForm1.Show
End Sub

Where would i add the control tip text code???