I have a macro with a user form that has 2 combo boxes in it. Currently the
second combo box contains all the possible options that could arise from the
items in the first combo box. I would like to change this so that the list
of items in the second box is driven by whichever item is chosen in the first
combo box.

I have managed to do this by splitting the user form into 2 separate boxes
(ie the user confirms choice 1 before the 2nd list of choices is shown) but
I'd prefer not to do that as the user may want to change their mind about the
first choice.

Any tips or suggestions of good reference material on the net would be
gratefully received. The 2 books I've got haven't given me any inspiration.

You ciould try dynamically setting the list items for the second box
every time the first is changed. You can do this by linking a macro to
the first list box's change event.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=547572