Mandatory TextBox Field - UserForm

[longbow007]

Hello, could some one please assist with the following code? I am using Excel 2003. I need to make a mandatory field for TextBox1 on UserForm2. So if the user leaves TextBox1 "blank", then they are forced to enter in data into TextBox1.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Kind regards,

Chris

[royUK]

Something like

Please Login or Register  to view this content.

[longbow007]

Thankyou royUK for your excellent help and assistance - your code works very well - very much appreciated.

Kind regards,

Chris