View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Entry into check box dependent on other check box.

How about using optionbuttons? That's the way they behave.

You may want to try this:
http://www.contextures.com/xlform01.html

Stilla wrote:

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!


--

Dave Peterson