Mistake in form to force correction.

[Wouldsman]

I have a form that will bring up a text box if the operator puts bad info into a cell.
This part seems to be working well.
My problem is they can just click on the sheet and by pass the text box.
Is there a way to prevent them from continuing on unless they correct the info inside the cell?

[:) Sixthsense :)]

Keep the form as modal so that it will not allow the user to move back to excel until and unless they close the current userform.

[Wouldsman]

Sixthsence,
Not sure what you are saying?

[Norie]

How are you displaying the form?

[Wouldsman]

Currently it is as a excel sheet. Why?

[Norie]

Well how are you displaying the 'text box' when there's a problem?