View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Making a Textbox Required Field

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