how do I add a caption to a picture in Excel
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
"Pranav Vaidya" wrote in message
...
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.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!
"SooDesuNe" wrote:
Thanks for the suggestion. That's what I'm doing currently. Is there a
way
with a little more finesse?
"Pranav Vaidya" wrote:
Place a text box on your picture and gropu both the objects.
HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!
"SooDesuNe" wrote:
I know Word has the ability to caption a picture (insert picture -
right
click on picture - Caption). Does Excel have similar functionality?
|