Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Combo box display (Excel 2000 SR1)

    Hi,

    I'd like a combo box to display two columns after I make a selection.

    The attached sheet shows the problem, the combo box shows the two columns while you select but after the selection is made the box only shows the first column.

    Is this possible?

    Jim MacLeod
    Shetland Isles

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Combo box display (Excel 2000 SR1)

    Hi Jim

    I have made modifications to your excel sheet. I used Forms toolbar. Concatanated your list and used the new list as the source. I have linked the combo to A1...hope this is what you wanted?
    Jerry

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Combo box display (Excel 2000 SR1)

    Perfect! Thanks very much,

    Jim

Posting Permissions

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