how to make newline in VB button caption on workshett?

[Guest]

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

 

[Guest]

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

 

[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