PDA

View Full Version : Solved: Use a spreadsheet specifies interval even if another is active



marreco
03-02-2013, 07:08 AM
Hi.

I need to take breaks
ComboBox1.RowSource = Worksheets ("Sheet2"). Range ("Table1"). Address

with the tab "Sheet1" I've been active, but the code below to select the tab "Sheet1" to ComboBox1, takes values ​​tab "Sheet1" and I pointed out that it is in line to pick up the tab interval "Sheet2"
Private Sub UserForm_Initialize()
With Sheet2
ComboBox1.RowSource = Worksheets("Sheet2").Range("Table1").Address
ComboBox2.RowSource = Worksheets("Sheet2").Range("Table2").Address
End With
End Sub
Thank you!!

p45cal
03-02-2013, 08:55 AM
ComboBox1.RowSource = Worksheets("Sheet2").Range("Table1").Address(external:=True)
ComboBox2.RowSource = Worksheets("Sheet2").Range("Table2").Address(external:=True)

or: ComboBox1.List = Application.Transpose(Worksheets("Sheet2").Range("Table1"))
ComboBox2.List = Application.Transpose(Worksheets("Sheet2").Range("Table2"))

marreco
03-02-2013, 11:09 AM
Hi

Yes!!!

Thank you!!!