Control Toolbar Button Caption

  • Thread starter Thread starter Otto Moehrbach
  • Start date Start date
O

Otto Moehrbach

Excel 2003, WinXP
A quick question:
When typing in the caption of a Control Toolbar button, how do you insert a
Carriage Return or "next line"? Thanks for your help. Otto
 
Ctrl-Enter worked for me.



Otto said:
Excel 2003, WinXP
A quick question:
When typing in the caption of a Control Toolbar button, how do you insert a
Carriage Return or "next line"? Thanks for your help. Otto
Click to expand...
 
Dave
I appreciate your help. However, that doesn't work for me. Here's what
I do:
I do View - Toolbars - Control Toolbar.
I click on the Design Mode icon.
I click on the button
In the Properties box, in Caption, I type:
"One Two Three" Ctrl - Enter "Four Five Six".
The caption I get is "Four Five Six"
I enlarged the box way more than needed. The same result.
I tried Alt - Enter, Shift - Ctrl - Enter, Ctrl - Enter.
Help! Otto
 
Dave
I tried Ctrl - Enter on a Forms toolbar button and that worked. But it
doesn't work on a Controls Toolbar button. Otto
 
Ooh. I should have mentioned that I rightclicked on the commandbutton, chose
"commandbutton object", clicked Edit (and then it worked ok for me).

But I did cheat to see if was possible with code like this:

Option Explicit
Private Sub CommandButton1_Click()
Me.CommandButton1.Caption = "Hi" & vbLf & "there"
End Sub
 
Glad you got it working. Sometimes the easiest things are the most difficult
(Huh)?
Otto said:
One black mark by Dave's name <g>.
Thanks Dave. That works for me too. Otto
Click to expand...
 
Back
Top