+ Reply to Thread
Results 1 to 3 of 3

If Statement in VB

  1. 03-03-2009, 07:07 AM #1
    INeedHelp09
    INeedHelp09 is offline
    Registered User
    Join Date
    03-03-2009
    Location
    Liverpool
    MS-Off Ver
    Excel 2003
    Posts
    4

    If Statement in VB

    I am looking to get my vb code to do a simple thing, i need it to look at a date on my excel doc and to flag a messagebox that it cannot run due to date passed only if the date is exceeded otherwise i would like the code to complete?? I am very new to all this also 

    Please Login or Register  to view this content.
    Last edited by mudraker; 03-03-2009 at 07:26 AM.
    Reply With QuoteRegister To Reply
  2. 03-03-2009, 07:15 AM #2
    alski
    alski is offline
    Registered User
    Join Date
    02-19-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003 and Excel 2007
    Posts
    37

    Re: If Statement in VB

    Try this - now returns a Date and Time whereas date returns just the date

    Please Login or Register  to view this content.
    Last edited by mudraker; 03-03-2009 at 07:27 AM.
    Reply With QuoteRegister To Reply
  3. 03-03-2009, 07:26 AM #3
    INeedHelp09
    INeedHelp09 is offline
    Registered User
    Join Date
    03-03-2009
    Location
    Liverpool
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: If Statement in VB

    I need it to stop at that point if the date is past todays date or for it to continue if it is not?? Hope this makes sense
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1