I am tring to create a combobox...

I have looked for hours on the net.

I have tried everything from just about 30 sites and I am still not able to create a combobox that works the way I need it to.

I have gotten the combobox to be created in a module. The combobox list is where I am having problems. I can place a rutine in the worksheet (Sheet1) and call it to make it work however I would like to be able to get the list in the combobox work without relying on the sheet or list ranges.

I am willing to use any other control that will work. So if there isn't a way to do it with the combobox then please let me know.

Thanks.

Also I would like any suggestions as to useing the same rutine in the sheet to populate other combobox controls I have created.

Just to clarify I am working with a spreadsheet. I want to have a user selectability to create a new row and that macro would create a new combobox with the same options each time.

Thanks again.

 Steve

I've read this a few times and am struggling to understand what it is you really want. Can you try and re-phrase or show us some code you have?