If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|