basically i have a command button and the caption is too long for me to fit it without making the button too wide. is there a way (some character or key combination) to make it start a new line at some point in the caption??
thanks
basically i have a command button and the caption is too long for me to fit it without making the button too wide. is there a way (some character or key combination) to make it start a new line at some point in the caption??
thanks
You can do it with code
Private Sub Userform_Initialize()
Userform1.CommandButton1.Caption = "ABCDE" & Chr(10) & "EFGHIJ"
End Sub
--
Regards,
Tom Ogilvy
"neowok" <neowok.23a3iz_1140020103.623@excelforum-nospam.com> wrote in
message news:neowok.23a3iz_1140020103.623@excelforum-nospam.com...
>
> basically i have a command button and the caption is too long for me to
> fit it without making the button too wide. is there a way (some
> character or key combination) to make it start a new line at some point
> in the caption??
>
> thanks
>
>
> --
> neowok
> ------------------------------------------------------------------------
> neowok's Profile:
http://www.excelforum.com/member.php...fo&userid=5940
> View this thread: http://www.excelforum.com/showthread...hreadid=512750
>
set the commandbutton.wordwrap property=true and then create the caption
using string concatenation such as
cmdbutton.caption ="First Line" & vbcrlf & "Second Line" & vbcrlf & "Third
line
--
www.alignment-systems.com
"neowok" wrote:
>
> basically i have a command button and the caption is too long for me to
> fit it without making the button too wide. is there a way (some
> character or key combination) to make it start a new line at some point
> in the caption??
>
> thanks
>
>
> --
> neowok
> ------------------------------------------------------------------------
> neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
> View this thread: http://www.excelforum.com/showthread...hreadid=512750
>
>
thanks they worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks