ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CommandButton Text (https://www.excelbanter.com/excel-programming/308949-commandbutton-text.html)

Grandad

CommandButton Text
 
Does anyone know of an easy way to have more than one line of text on the
face of a button?

--
Kind Regards

Mick



Tom Ogilvy

CommandButton Text
 

What kind of button

but:
Sheet4.commandbutton1.Caption = "ABCD" & chr(10) & "CDEF"

would probably be the easiest way.

--
Regards,
Tom Ogilvy

"Grandad" wrote in message
...
Does anyone know of an easy way to have more than one line of text on the
face of a button?

--
Kind Regards

Mick





SunTzuComm

CommandButton Text
 
Make sure the button's WordWrap property is set to True. Then you can
experiment with the Height and Width to control how the caption breaks.

Regards,
Wes

Mick[_7_]

CommandButton Text
 
Thanks both, I had missed the wordwrap property

Mick

"SunTzuComm" wrote in message
...
Make sure the button's WordWrap property is set to True. Then you can
experiment with the Height and Width to control how the caption breaks.

Regards,
Wes





All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com