how do I add a caption to a picture in Excel

[Guest]

I know Word has the ability to caption a picture (insert picture -> right
click on picture -> Caption). Does Excel have similar functionality?

 

[Guest]

Place a text box on your picture and gropu both the objects.

HTH,

 

[Guest]

Thanks for the suggestion. That's what I'm doing currently. Is there a way
with a little more finesse?

 

[Guest]

Hi,

I tried doing it several ways in Word and Excel also, not much luck.
I think this is the best possible way, unless one of the experts share their
views.

 

[Rick Rothstein \(MVP - VB\)]

I'm not an expert here, but you could use a Label (either from the Form's or
Visual Basic toolbars) instead of a TextBox... then the Label's framework
would be transparent for the Form's Label or you could set the Label's
BackStyle property to 0-fmBackStyleTransparent for the Visual Basic Label...
that way only the text (without any framing) will show on top of the
picture... that might look better for what you are doing.

Rick