how to make newline in VB button caption on workshett?

[Rich]

Hello,

Is it possible to add/make a newline on a VB button on a worksheet? How can
I do this? I added a button on a worksheet to run a macro. I need to make
the caption descriptive, but I don't want to drag the button to the length of
the activewindow. I can only add text through the property sheet of the
button. Is there a way to add a newline char to the caption text?

Thanks,
Rich

[Rich]

I found the property I needed. Set WordWrap to true. Now I have my newline.

"Rich" wrote:

> Hello,
>
> Is it possible to add/make a newline on a VB button on a worksheet? How can
> I do this? I added a button on a worksheet to run a macro. I need to make
> the caption descriptive, but I don't want to drag the button to the length of
> the activewindow. I can only add text through the property sheet of the
> button. Is there a way to add a newline char to the caption text?
>
> Thanks,
> Rich

[Zack Barresse]

Hello Rich,

You can either do this via code or you can manually do it. To manually do
this, enter your data in a blank cell using Alt + Enter key combination for
a line break. Once you have it in your cell, copy it. Then open your
Properties window and select the Caption property value and press Ctrl + V.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM



"Rich" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> Is it possible to add/make a newline on a VB button on a worksheet? How
> can
> I do this? I added a button on a worksheet to run a macro. I need to
> make
> the caption descriptive, but I don't want to drag the button to the length
> of
> the activewindow. I can only add text through the property sheet of the
> button. Is there a way to add a newline char to the caption text?
>
> Thanks,
> Rich