I’ve done some reading about comboboxes but need help.
I need to populate a combobox (Sheet1) with items from (Sheet2). Sheet2 has several lists starting in A1 the number of lists will vary. All lists are three columns apart and one column wide.
Sheet2
<tbody>
</tbody>
I would like to display each date + Name as a combobox item.
When I select a combobox item it would like for that item to be selected on Sheet2. Is it possible?
Please suggest some code.
Thanks,
Lenna
I need to populate a combobox (Sheet1) with items from (Sheet2). Sheet2 has several lists starting in A1 the number of lists will vary. All lists are three columns apart and one column wide.
Sheet2
1/2/2013 | | | | 2/5/2013 | | | | 3/6/2013 | | | | 4/7/2013 | | | | 5/7/2013 | | | |
| | | | | | | | | | | | | | | | | | | |
Name1 | | | | Name2 | | | | Name3 | | | | Name4 | | | | Name5 | | | |
<tbody>
</tbody>
I would like to display each date + Name as a combobox item.
When I select a combobox item it would like for that item to be selected on Sheet2. Is it possible?
Please suggest some code.
Thanks,
Lenna