how to make newline in VB button caption on workshett?
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 |
how to make newline in VB button caption on workshett?
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 |
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 |
All times are GMT +1. The time now is 09:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com