Force entry in textbox on userform

How do I force a user to fill in a textbox on a userform (make it a "required entry"), before allowing them to go onto the next entry on the form. Would it be better to do this when all other fields have been filled in?

Thanks,

OM1950

Good morning OM1950

I would do a simple check at the end - you usually have a "Go" button that will do something with the data entered. Just insert a simple routine that will cancel the action if the textbox is unfilled.

Please Login or Register  to view this content.

HTH

DominicB

Thanks Dominic - thought that might be the best way to do it.

OM1950