View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
abxy[_37_] abxy[_37_] is offline
external usenet poster
 
Posts: 1
Default Another Quick Simple VBA question (if...then statement)

Thanks everyone, you all were a big help...Actually last night,
wasn't getting any response so i just decided to fool around and I cam
up with a solution but it wasn't working properly(working in som
cases, but then not in others); it was this:

If cboMonth.Value = "Febuary" And Date "2/06/04" Then

chkWk1.Enabled = True

End If

then I saw you all's repsonses this morning and so i altered it t
this:

If cboMonth.Value = "Febuary" And Date DateValue("2/06/04") Then

chkWk1.Enabled = True

End If

and it works perfect now...i guess the statement DateValue was neede
to fine tune things

Thank you veeeeeerry much everyone, i really appreciate you all's help

--
Message posted from http://www.ExcelForum.com