Combobox on excel sheet

[mtanneryd]

Hi!

I'm trying to do something that I thought would be easy but I cannot get the hang of it even so. I have placed a form combobox on my sheet and I would like to fill it from VBA code. But, I cannot even figure out how to refer to the combobox object from VBA. I'm using Excel 2007.

Any help would be much appreciated.

/Måns

 

[VoG]

Try like this

Sub test()
ActiveSheet.OLEObjects("ComboBox1").ListFillRange = "A1:A10"
End Sub