ComboBox rowSource

Mar 13th, 2002, 05:19 PM

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 · Mar 14th, 2002, 12:21 AM

Code should work ??

How have you defined lastusedrow ??

Ivan

Mar 14th, 2002, 01:28 AM

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 05:19 PM	#1
Guest Posts: n/a	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

Mar 14th, 2002, 12:21 AM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Code should work ?? How have you defined lastusedrow ?? Ivan

Mar 14th, 2002, 01:28 AM	#3
Guest Posts: n/a	WorkSheets("Sheet1").Select lastUsedRow = Range("AA65536").End(xlUp).Row is it correct? lastUsedRow is the last row in column AA that has data.