View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon[_5_] Simon[_5_] is offline
external usenet poster
 
Posts: 3
Default Excel/VBA - month dates

Hi there,

I am trying to develop something using VBA that says

If the say B1 cell is greater than April
then
perform an action.

B1 contains a date, say 01/08/03.

I cant seem to get it to recognise that the month in B1 is
greater than April? I can do it in excel but not using
VBA code.

Thanks alot

Simon