View original (French)

Mandatory fields must be filled in to proceed

#jquem# Posted messages 76 Status Member -  
Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   -
Hello,
I would like to make the filling of cell B1 mandatory after cell A1 has been filled.
As long as B1 is not filled, it would be impossible to enter anything in any other cell of the table, nor to save this table.

Thank you in advance for your help.

2 answers

  2.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hello,
    for A1 you can keep it simple, select A1 then Data/Data Validation/Options tab/under Allow select Custom/in Formula paste this formula
    =$B$1<>""
    uncheck Ignore blank and OK

    However, regarding
    "It would be impossible to enter anything in any other cell of the table, nor to save this table" that is not very clear

    To handle saving, you absolutely have to go through VBA if you have some knowledge
    Catch you later
    Mike-31

    I am responsible for what I say, not for what you understand...
    0