Well boss is ditching the upon saving....you stated that they can't move onto
the next UserForm without filling in these textboxes on the UserForm. Would
if I am using just the worksheet instead of a UserForm.....It will bring up
the message box, but does not stop them from moving on to next worksheet/tab
per say?

"ryguy7272" wrote:

Hummm, not sure what you mean 'required fields to be check upon saving'. Can
you give me a more detailed example? You can't move out of the
current/active UserForm when you use the code I gave you on each TextBox --
the code prevents you from moving to the next UserForm until all the
TextBoxes on the current UserFrom have been filled out (or filled in...never
understood the difference).

Regards,
Ryan--

--
RyGuy


"LRay67" wrote:

That works great, maybe you could help me....My boss would like these
required fields to be check upon saving the workbook. Any suggestions?

Linda

"ryguy7272" wrote:

This (simple) technique works great for me:

Sub
If TextBox1 = "" Then
MsgBox "Please enter a value for 'whatever'!!"
Exit Sub
End If
End Sub


Regards,
Ryan--


--
RyGuy


"LRay67" wrote:

How would I make a textbox a required field for the user to enter information?

Thanks

Linda