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