Forum Discussion

Seaneboy2020's avatar
Seaneboy2020
Copper Contributor
Oct 27, 2020

DATA VALIDATION - DON'T ALLOW BLANK CELLS

Hello,   I'm trying to create a data validation error message, where by the message will appear when the user leaves a certain cell blank. I want the user to only be able to enter text within the r...
excel
Seaneboy2020's avatar
Seaneboy2020
Copper Contributor
Oct 27, 2020

Hi PReagan 

 

Thank you very much for your reply.

 

Do you know any other solutions which could help resolve this issue? As it's most likely that the user will simply ignore the required cell, which needs to be completed.

 

Many thanks

PReagan's avatar
PReagan
Bronze Contributor
Oct 27, 2020

Seaneboy2020

 

Unfortunately, without running a macro, Excel does not allow this. Please review the following post for a better explanation:

https://stackoverflow.com/questions/55616477/prevent-blank-cells-with-data-validation

  • Seaneboy2020's avatar
    Seaneboy2020
    Copper Contributor
    Oct 27, 2020

    PReagan 

     

    Thank you very much for your help.

Resources