ComboBox RowSource Question
For a given form can I reference multiple sheets within a workbook? Here is
what I tried to do but it failed on the second ComboBox.
....
ComboBox1.RowSource = Sheets("Sheet1").Range(Cells(1,1),Cells(10,3).Addr ess
.....
.....
ComboBox2.RowSource = Sheets("Sheet2").Range(Cells(1,1),Cells(10,3).Addr ess
Thanks
Mike
|