View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rod Taylor Rod Taylor is offline
external usenet poster
 
Posts: 11
Default Time Format & Unload problem

Someone asked for the code on the unload issue
If Leave_REQ = "" Or REQ_CONT_INT = "" Or AL_DMN = "" Or AL_ConTyp = "" Or
ST_Time = "" Or ET_Time = "" Then
MsgBox ("You must Fill in all INFO to make A Request")
Leave_REQ = "": ST_Time = "": ET_Time = "": REQ_CONT_INT = "": REQ_INFO
= ""
AWS = "": AL_DMN = "": SHFT = "": TODAY_TIME = "": FPE = "": AL_ConTyp = ""
End If


This is the if statment and it cleares all the info would rather not clear
the info but allow the user to fill in the required info.