Solved: populate combobox problem

[gibbo1715]

Hi All

Can anyone tell me what is wrong with the code below please as it doesnt add anything to my combobox?

thanks

Gibbo

[VBA]Dim iLastRow As Long

iLastRow = Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Row

ActiveWorkbook.Names.Add Name:="PopulateCombo", RefersToR1C1:=Sheets("Sheet2").Range("A1:A" & iLastRow)

Me.ComboBox1.RowSource = PopulateCombo[/VBA]

[malik641]

Hey Gibbo,

Try:

[VBA]Me.ComboBox1.RowSource = Range("PopulateCombo").Address[/VBA]

Good luck!

[benny]

Hi Gibbo,

Add quotes.

Me.ComboBox1.RowSource = "PopulateCombo"

[malik641]

Nice one benny Didn't think of that!

[gibbo1715]

Thankyou both,

cant believe it was that simple

Gibbo