Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
require cell to edit
Hello,
I'm actually working on Excel questionnaires. So I have lots of questions that need to be filled in the correct order. I would like to lock or disable every next cells until the previous answer is not filled. If possible without using Macros or VBA Thank you very much. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
require cell to edit
You could use custom validation. Data - Validation - Custom
In the formula add something like the cell above < "" (for example highlight cells A2:A10 and add validation =A1<"". Be sure to uncheck ignore blanks. This means that the cell above the current cell must be filled in before you can fill in the current cell. First A1 then A2 then A3... -- HTH... Jim Thomlinson "Sem" wrote: Hello, I'm actually working on Excel questionnaires. So I have lots of questions that need to be filled in the correct order. I would like to lock or disable every next cells until the previous answer is not filled. If possible without using Macros or VBA Thank you very much. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
require cell to edit
Thanks for the answer, this solve the main part of the problem. The only
remaining problem is that I already used validation to provide in-cell drop-down lists for some question, so I think this is not possible to use those 2 validation types at the same time. Is there another way to do that? Or maybe another way to provide the drop down list? As I said in the first question, I wouldn't like to use VB controls. "Jim Thomlinson" wrote: You could use custom validation. Data - Validation - Custom In the formula add something like the cell above < "" (for example highlight cells A2:A10 and add validation =A1<"". Be sure to uncheck ignore blanks. This means that the cell above the current cell must be filled in before you can fill in the current cell. First A1 then A2 then A3... -- HTH... Jim Thomlinson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel |