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

    Question Unanswered: combo box help again

    into this combo box i need to put in a group of cells from A5 to D39 how do i do this without only getting the first column that i selected( i am using combo box from the forms menu)
    Ben

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Your best bet is probably going to be concatenating those cells.

    In column E add the following formula:

    =A5&" "&B5&" "&C5&" "&D5

    and copy down.

    Now set the ComboBox's Input Range to E5:E39.

    You can also hide A or E if necessary.

    Hope that helps,

    Smitty

  3. #3
    Join Date
    Jan 2004
    Posts
    17
    yeh thanx thats one way to do it

Posting Permissions

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