+ Reply to Thread
Results 1 to 4 of 4

multi line caption on command button??

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Posts
    154

    multi line caption on command button??

    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

  2. #2
    Tom Ogilvy
    Guest

    Re: multi line caption on command button??

    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
    >




  3. #3
    John.Greenan
    Guest

    RE: multi line caption on command button??

    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
    >
    >


  4. #4
    Forum Contributor
    Join Date
    02-09-2004
    Posts
    154
    thanks they worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1