LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dates of month rejoyce40 Excel Discussion (Misc queries) 5 November 13th 08 06:01 PM
Excel 07 - Line Chart with Month-end dates Lori Charts and Charting in Excel 3 August 7th 08 06:50 PM
Dates - Several Days In a month to month only Andy_Pimp Excel Discussion (Misc queries) 1 February 28th 06 11:11 AM
Am I able to sort dates by month rather than year in excel? Ruth k. Excel Discussion (Misc queries) 1 November 3rd 05 03:18 PM
How do I sort a list of dates in Excel by month and day? Caroline Excel Discussion (Misc queries) 3 June 10th 05 11:58 PM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"