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

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

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" wrote in message
...
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