Thread: Disallowing a blank text box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Yngve Yngve is offline
external usenet poster
  
Posts: 67
Default Disallowing a blank text box
Hi Kristen

Somthing like this, prompt the user to put in a value.

if textbox1 = "" then
msgbox "Enter a value"
TextBox1.SetFocus
endif

Regards Yngve

Reply With QuoteReply With Quote