Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i have a check display with any data entry in a cell | Excel Discussion (Misc queries) | |||
Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
check boxes - copy | Excel Discussion (Misc queries) | |||
Cell value dependent on another cell entry | Excel Discussion (Misc queries) | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) |