ComboBox1

Can I have a ComboBox on sheet 1 and have the list fill on sheet2? Not sure how too get it too read sheet2,

Hi,

not sure if you mean the ComboBox control, which is used in a VBA form or if you simply want a dropdown list when you click in a cell to select from a list of values. The dropdown list is done with data validation, and yes, you can have the list on a separate sheet.

1. set up your list
2. select the whole list and assign it a range name (Insert - Name - Define), for example MyList
3. on the other sheet select the cell in which you want the dropdown list
4. go to Data - Validation
5. select List
6. in the Source box type

=MyList

hope that helps

in that case

1. set up your list
2. select the whole list and assign it a range name (Insert - Name - Define), for example MyList
3. on the other sheet create the combo box
4. in the properties go to the ListFillRange and set it to MyList

hth

1. Go to Sheet2
2. Highlight the list
3. Click Insert - Name - Define
4. Type "Mylist" in the "Names in Workbook" box
5. Click OK
6. Go to Sheet1
7. Click the Design Mode icon on the Control Toolbox toolbar
8. Right click on the ComboBox and select Properties
9. In the Properties list scroll down to the field ListFillRange
10. Click in the empty box to the left and enter "Mylist"
11. Close the Properties box
12. Exit Design Mode (click the Design Mode icon again)
13. use the Combo Box

oh, and clear out your existing code for the ComboBox in the VBA editor. It's only throwing errors around, anyway.