Simple code, But whats wrong with it? <Resolved>

[Morpheus]

Can anyone help me here, i am trying to populate a combobox from excel using a range of numbers. I have the below code, however the list is not populating, and i know this is possible, just maybe not the way i'm doing it.

I just want it populated at runtime, so the user can select from the info contained in it.

'appExcel.Workbooks.Open FileName:="C:\Program Files\LFhost\Maccrystal01.xls"
appExcel.Worksheets("dblisting").Select
cmbbx.AddItem = appExcel.Range("a1:a255")


Additonally, is there a way to stop it from duplicating items? they can occur up to 19 times each. I only want a list of one of each value.


As always help is alway appreciated.
M