Run Time Error 70 Permission denied - populate combobox from table column

[LukeP1]

Hi,

I have a combo box that I'd like to have populate with data from a table column in Excel. I am using the code below, but am getting a 'Run Time Error 70 Permission denied'. Can anyone tell me what I am doing wrong?

Many Thanks

Private Sub ComboBox1_initialize()

Me.ComboBox1.List = Worksheets("BQ Lists").ListObjects("Biils").ListColumns(1).DataBodyRange.Value

End Sub

 

[Domenic]

That's probably because you have the RowSource property set for your combobox. Either manually clear the setting from the Properties Window (F4) or use the following line of code to clear it...

Me.ComboBox1.RowSource = ""

Hope this helps!

 

[LukeP1]

That's probably because you have the RowSource property set for your combobox. Either manually clear the setting from the Properties Window (F4) or use the following line of code to clear it...

Me.ComboBox1.RowSource = ""

Hope this helps!

Problem solved, thank you so much!!

 

[Domenic]

You're very welcome, cheers!