Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CommandButton as array ? apis Excel Discussion (Misc queries) 2 November 17th 11 05:36 PM
CommandButton Alvin Hansen[_2_] Excel Programming 3 August 16th 04 06:35 PM
CommandButton chris[_12_] Excel Programming 1 April 15th 04 01:01 AM
CommandButton rwebster3 Excel Programming 0 April 14th 04 08:16 PM
Commandbutton David Fixemer Excel Programming 2 February 25th 04 10:18 PM


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"