G
Guest
Guest
Help....My codes:
ComboBox1.RowSource = "'Sheet1'!AA1:AA" & lastUsedRow
ComboBox1.Value = Range("AA" & lastUsedRow).value
cannot work
Could you explain me how can i change the comboBox1.RowSource? the rowSource of ComboBox1 is always the "AA1:AA8" which was the range i defined in the userForm design. Later in my program i need to expand the rowSource...
Could you enlighten?
Thx
ComboBox1.RowSource = "'Sheet1'!AA1:AA" & lastUsedRow
ComboBox1.Value = Range("AA" & lastUsedRow).value
cannot work
Could you explain me how can i change the comboBox1.RowSource? the rowSource of ComboBox1 is always the "AA1:AA8" which was the range i defined in the userForm design. Later in my program i need to expand the rowSource...
Could you enlighten?
Thx