View original (French)

Cell must be filled in order to proceed.

Spooty Posted messages 30 Status Membre -  
Spooty Posted messages 30 Status Membre -
Hello everyone,

First of all, I am working with Excel 2010 and Windows 7.

I am trying to find out if it is possible to "force" a user to fill in one or more cells before they can move on.

For example, in one box there is a last name, and then, in a second one, there is a first name. I would like to be able to create a "next" button that would only appear if both cells have been filled in.

Is this possible? And if so, how?

Thank you in advance for your valuable help and best regards.

Spooty

6 réponses

Réponse 1 / 6
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
Hello,

try with data validation
for example, you want to allow entry in B2 if A2 is filled in, then C2 if B2 is filled in, etc.
activate your cell B2 then Data Validation / Options tab select Custom and enter this formula =A <>""
increment this cell to the right

you can customize the alert message

A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.
1
Spooty Posted messages 30 Status Membre 2
 
Hello Mike

THANK YOU very much for this response! It’s great for the cells that need to be filled.

But is there also a solution like this when the user then needs to use a button where a macro is activated? (Basically, if they haven't filled out the entire form, the "Next" button wouldn't work?)

Thanks again and best regards.

Spooty
0