![]() |
how do I add a caption to a picture in Excel
I know Word has the ability to caption a picture (insert picture - right
click on picture - Caption). Does Excel have similar functionality? |
how do I add a caption to a picture in Excel
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? |
how do I add a caption to a picture in Excel
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? |
how do I add a caption to a picture in Excel
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? |
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? |
All times are GMT +1. The time now is 09:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com