View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Samyn Mike Samyn is offline
external usenet poster
 
Posts: 2
Default 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