Making a Textbox Required Field

[LRay67]

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

Thanks

Linda

 

[ryguy7272]

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--

 

[LRay67]

Thanks Works Great

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--

 

[LRay67]

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]

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--

 

[LRay67]

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]

Well, that is totally different; a worksheet is totally different from a
UserForm. If you are in the UserForm environment, the code prevents you from
moving out of the UserForm. If you are working on the Sheet, then you are
not in the UserForm environment and thus the code is ignored.

Regrads,
Ryan---