Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    17

    Question Unanswered: combo box problem

    i have a combo box in excel but i want to put some information in it from another sheet, however it wont work when i highlight the cells that i want, it will only enter the first row that i selected. how can i get around this?
    ben

  2. #2
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    Hi Ben,

    If You use datavalidation or the combobox from the Forms toolbar then You need to create a named range and then assign the rangename as source for the control, like =MyRange

    Kind regards,
    Dennis
    Kind regards,
    Dennis

  3. #3
    Join Date
    Jan 2004
    Posts
    17
    yeh thanx i just tried this but it will only copy the first row of information into the combo box

  4. #4
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    Hi Ben,

    It sounds as You have Your list in a row and that the first value is only available in the combobox.

    AFAIK it is by design and need either be solved with a list in a column (manually or refer to the original list and use the TRANSPOSE-function) or with VBA.

    The Datavalidation can handle a list in a row.

    Kind regards,
    Dennis
    Kind regards,
    Dennis

Posting Permissions

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