I assume you ran ShowDialog after the comboboxes were added.

As I said, I copied the code out of a workbook where it was working very
well.

Can't say why you are having a problem. I have used this approach with
comboboxes, checkboxes, commandbuttons etc. Never a problem.



--
Regards,
Tom Ogilvy



steve bell wrote in message
...
Tom,

Your continued support and patience is muchly appreciated!

But something isn't working. Copied and pasted the 2 macros as
instructed. (The first into a standard module, the second into a class
module). Double checked that I am using MsForms combobox (your previous
code for drop down uses this reference and it works great).

Nothing happened.

Inserted a new worksheet and added a couple of combo boxes and still
nothing happened. Set some breakpoints and the macros aren't being
fired. (double checked events abled to make sure). Even tried a forms
combo box.

Something is happening though I'm not sure what it is. When I make a
selection in any of the combo boxes and click the VB icon - the screen
flashes and returns to Excel. Click it again and it indicates a VB
minimize. Click it again and I finally get to the VBE. Alt+Tab
switches just fine. So something is being triggered, but I can't tell
what.

And now when opening the file I am getting 'The file is being modified
by me and is Read Only'. This is also happening on my Personal.xls (at
work and at home). Remember seeing some discussion on this before but
could'nt find it - except reference to cleaning Temp folders (which I
have done). Am now going to reboot and see what happens...

steve

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!