Change code to require a Response

Hello All,

Ok ive been asked by the boss to make some changes to the code below:

Boss want the user's to be required to fill in the Two fields before being aloud to procede to the next step in the inventory.
I marked the fields that require a response:

Please Login or Register  to view this content.

As always thank's for Your Help with this


Aeneren

AlvaroSiza,

Thanks for the Response, Your change does work but i am looking more along the lines of the user having to pick there name and Truck number from the Data Validation Lists that are already in the workbook.

Ive attached a small example file this time for your viewing.

Aeneren

Inventory Sample-3.xlsm

Paul,

Thank you for your response as well

All 3 of them lol, thinking the boards got a glitch tonight

Aeneren

Paul,

Your Code is working a Msg box comes up If one or both fields are open, but as soon as i click OK it advances to the next Sheet.

Please Login or Register  to view this content.

is it possible the macro that the Start Inventory is activating is the cause.

Please Login or Register  to view this content.

Thanks Aeneren

Paul,

Same thing again i am uploading the test Book im using also.



Aeneren