Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Get Year From Current Date In VBA

  1. #1
    Join Date
    27th December 2007
    Posts
    70

    Get Year From Current Date In VBA

    What is the code to call upon the current year in vba code?

    Thanks in advance!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,322

    Re: Calling Upon The Current Year In Vba Code

    VB:
    iYear=Year(Date) 
    
    
    Entia non sunt multiplicanda sine necessitate.
    MS MVP - Excel

  3. #3
    Join Date
    27th December 2007
    Posts
    70

    Re: Calling Upon The Current Year In Vba Code

    Thanks

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Get Month & Year X Months From Current Date
    By raggyryan in forum EXCEL HELP
    Replies: 9
    Last Post: May 8th, 2008, 06:24
  2. Text Based On Date Being Year From Current Date
    By Spoony in forum EXCEL HELP
    Replies: 3
    Last Post: April 30th, 2008, 12:23
  3. Replies: 8
    Last Post: April 24th, 2008, 09:21
  4. Current year + 3 years
    By chimp in forum EXCEL HELP
    Replies: 6
    Last Post: November 9th, 2005, 20:34
  5. convert date field year xx to year xxxx
    By sophism in forum EXCEL HELP
    Replies: 4
    Last Post: January 17th, 2005, 16:34

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
  •  
porno