I assume that you mean you have designed a worksheet to be used as a
questionaire!

I recommend using a DV dropdown for user choices with 'helper' columns
to render result combinations based on the user's selection. This will
eliminate the need for using controls (and their associated overhead),
simply the process, and provide the same (or better) quality experience
for the user!<IMO

The helper cols (and/or rows) can be hidden so your questionaire has a
cleaner look. Since you are advanced at using formulas/functions then I
expect you will have no problem designing a calc mechanism for which
'solution' to return based on how your helper cells evaluate their
respective DV dropdown selection.<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion