Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multipage user form tab names (Excel Office 2000)

    Hi,

    I have been chipin away on a user form and would love to learn how to name the tabs of a multipage user form by drop down boxes.

    attached is my form click the show form.

    you will see some drop downs,

    under the title page NAME
    there is 1 : 12 drop downs,

    I was wondering what kind of oject code would I have to put behind the comboboxes to chage the tab names using the drop downs.

    Drop down with a 1 to the left would name tab page 2 with what ever is stored in the dropdown
    and so on to page 13 tab

    thanks for the help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multipage user form tab names (Excel Office 2000)

    Like this:

    Private Sub ComboBox1_Change()
    Me.MultiPage1.Pages(1).Caption = Me.ComboBox1
    End Sub

    and similar for the other combo boxes.

    Note: Pages(1) refers to the second tab page, for we start counting at 0 for the first page.

  3. #3
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multipage user form tab names (Excel Office 2000)

    thanks for the speedy reply,

    one question, since the name from the compox is rather long is it possible to only use the first 7 characters from the left on the combobox value?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multipage user form tab names (Excel Office 2000)

    Yes:

    Me.MultiPage1.Pages(1).Caption = Left(Me.ComboBox1, 7)

  5. #5
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multipage user form tab names (Excel Office 2000)

    Thank you that was a big help to make this form look better

Posting Permissions

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