Hi,

I'm looking for a little help to do the following. Any info is greatly appreciated.

I'm trying to write a macro in XL that when run, will first pop up a combo box. The combo box needs to be filled by a range of cell values on the fly. Secondly, once the combo box is visible, I need to fire the click event of this combo box. Lastly, the combo box will be removed.

So, I need to:
--Have the user run a macro.
--Macro adds a combo box dialogue and fills with a range of cells on the active sheet.
--Once a selection is made in the combo box an event will be fired.
--Delete the combo box.

Thanks for the help.

Cheers,
Ed