ComboBox help

[dickep]

This has probably been asked and answered but for the life of me I cannot find it. :banghead:

I have attached a file that I "plagerized" from here (I think). :thumb

I just need to know how to populate the combobox with the data in the spreadsheet.

I am new to the forms and can't figure it out. :help

Thanks
E

[Bob Phillips]

I think you will need to give us more assistance than that, ther is plentyof code in there but it doesn't seem to do anything (yet?)

[dickep]

Yes, there is a lot of code.

I cannot figure out how to populate the combobox with the range on Sheet1. I have tried .AddItem in the With area, tried .RowSource (Object not allowed error when running), but to no avail.

I would like to populate it with the 3 columns of data, but only show the 3rd column. Then when I click the accept button (not yet there), the column 1 and 2 data will be entered into two variables for later processing.

Doable????

E

[Bob Phillips]

What combobox, there is no combobox. The code makes some reference to one, but without breaking the code down (which I ain't gonna do), I cannot see what you are trying to do, to what, or how.