Validating Data in User Forms

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


I have a fairly simple issue but am not quite sure what the solution is:

Have created a basic form in Excel with several combo boxes.
The combo drop down values are "Y" or "N".

I have a command button that adds the values to a work*** and clears the
combo boxes.

How do I prevent users from adding blank values to the work***? Ideally,
I would like to create an error routine/procedure which informs the user that
no blank values are allowed and highlights (or moves the cursor to) the field
with the blank value.

Thanks.

JPA.
.

Quantcast