Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to restrict user to input only one of multiple cells
Hello, here's a problem I've been wrestling with. Is there any way to design
a worksheet that would only allow a user to enter a value in one of a group of cells? For example, suppose A1, B1, and C1 were my group, corresponding to outcomes like positive/neutral/negative. If the user makes an entry in B1, say, the worksheet would disallow and/or delete anything in A1 or C1. I know you can do this in VB, and I know you could avoid the problem entirely by simply having one cell that was restricted (via Data Validation) to the three outcomes above. But neither of these are options for me. Anyone know how to do this as described? James |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to restrict user to input only one of multiple cells
You are correct! Data Validation is the solution.
Data Validation Settings Custom Formula =COUNTA($A$1:$C$1)<2 -- Gary''s Student - gsnu200802 "James" wrote: Hello, here's a problem I've been wrestling with. Is there any way to design a worksheet that would only allow a user to enter a value in one of a group of cells? For example, suppose A1, B1, and C1 were my group, corresponding to outcomes like positive/neutral/negative. If the user makes an entry in B1, say, the worksheet would disallow and/or delete anything in A1 or C1. I know you can do this in VB, and I know you could avoid the problem entirely by simply having one cell that was restricted (via Data Validation) to the three outcomes above. But neither of these are options for me. Anyone know how to do this as described? James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching cells from user input | Excel Discussion (Misc queries) | |||
Restrict-Filter-Limit-Validate user input in Excel | Excel Discussion (Misc queries) | |||
how do I restrict cell input to dates only? | Excel Discussion (Misc queries) | |||
Restrict input into cell array | Excel Discussion (Misc queries) | |||
Restrict input if amount is exceeded | Excel Worksheet Functions |