ComboBox rowSource

[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

 

[Ivan F Moala]

Code should work ??

How have you defined lastusedrow ??


Ivan

 

[Guest]

WorkSheets("Sheet1").Select
lastUsedRow = Range("AA65536").End(xlUp).Row

is it correct? lastUsedRow is the last row in column AA that has data.