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!!
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!!