Populating a ComboBox

[spg2112]

Hello All,

I need to populate a ComboBox in a personal workbook, so I can't use named ranges for a RowSource, or the ListFill property. How can I do this?

Steve

 

[Juan Pablo González]

See if this works

http://www.mrexcel.com/board2/viewtopic.php?t=71884

or this:

http://www.mrexcel.com/board2/viewtopic.php?t=70763

 

[spg2112]

Yes! Thank you Juan...very helpful. I ended up using the AddItem function. Oddly enough it doesn't seem compatible with Excel 2000 operating on WIn2000, vs. my work Excel XP and Win2000. Any ideas on this?

Steve