View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Zack Barresse[_3_] Zack Barresse[_3_] is offline
external usenet poster
 
Posts: 101
Default how to make newline in VB button caption on workshett?

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