Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-line text on a CommandButton
Hi,
I am using Excel 2007. I have inserted an ActiveX Command Button on a worksheet. I can enter descriptive text in the "Caption" field and this text is displayed on this Command Button. I can only seem to enter one line of text this way. Can anyone tell me if there is a way I can enter a second line of text to be displayed on the Command Button? Thanks in advance, Paul Kraemer -- Paul Kraemer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-line text on a CommandButton
What happens when you hold down the Shift key and hit Enter?
-- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Paul Kraemer" wrote: Hi, I am using Excel 2007. I have inserted an ActiveX Command Button on a worksheet. I can enter descriptive text in the "Caption" field and this text is displayed on this Command Button. I can only seem to enter one line of text this way. Can anyone tell me if there is a way I can enter a second line of text to be displayed on the Command Button? Thanks in advance, Paul Kraemer -- Paul Kraemer |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-line text on a CommandButton
If you rightclick on the commandbutton (while in design mode), you can choose:
Commandbutton Object|Edit And type the caption you want. Use ctrl-enter to force a newline in that caption. Paul Kraemer wrote: Hi, I am using Excel 2007. I have inserted an ActiveX Command Button on a worksheet. I can enter descriptive text in the "Caption" field and this text is displayed on this Command Button. I can only seem to enter one line of text this way. Can anyone tell me if there is a way I can enter a second line of text to be displayed on the Command Button? Thanks in advance, Paul Kraemer -- Paul Kraemer -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-line text on a CommandButton
And if you wanted to do it in code:
Worksheets("Sheet1").CommandButton1.Caption = "hi" & vbLf & "there" Paul Kraemer wrote: Hi, I am using Excel 2007. I have inserted an ActiveX Command Button on a worksheet. I can enter descriptive text in the "Caption" field and this text is displayed on this Command Button. I can only seem to enter one line of text this way. Can anyone tell me if there is a way I can enter a second line of text to be displayed on the Command Button? Thanks in advance, Paul Kraemer -- Paul Kraemer -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Line text box | Excel Discussion (Misc queries) | |||
Multi-Line Text In Same Cell | Excel Discussion (Misc queries) | |||
Formatting multi-line text | Excel Programming | |||
multi-line text file import to excel | Excel Programming | |||
Multi-line cell text content saved in XML | Excel Programming |