| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit data entry in range of cells
I have 6 columns with headings that repeat in a row. Users should make a
check under a maximum of 3 out of the 6 heading choices--is there a way to restrict them to only select 3 or less? Additionally, the data they can select needs to be limited. For example, they may place checks under 2 snacks and 1 meal, but not 3 meals or 3 snacks. Thanks for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit data entry in range of cells
Are you using clickbox?
"JStiehl" wrote: I have 6 columns with headings that repeat in a row. Users should make a check under a maximum of 3 out of the 6 heading choices--is there a way to restrict them to only select 3 or less? Additionally, the data they can select needs to be limited. For example, they may place checks under 2 snacks and 1 meal, but not 3 meals or 3 snacks. Thanks for your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit data entry in range of cells
No, I am not using clickbox.
"swastik" wrote: Are you using clickbox? "JStiehl" wrote: I have 6 columns with headings that repeat in a row. Users should make a check under a maximum of 3 out of the 6 heading choices--is there a way to restrict them to only select 3 or less? Additionally, the data they can select needs to be limited. For example, they may place checks under 2 snacks and 1 meal, but not 3 meals or 3 snacks. Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit data entry to 1/4" increments | Excel Discussion (Misc queries) | |||
| How can you limit the data entry range in Excel? | Excel Worksheet Functions | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
| Range name limit for data validation | Excel Worksheet Functions | |||
Linear Mode
