+ Reply to Thread
Results 1 to 5 of 5

Help with VBA for Date Change Macro

  1. #1
    Registered User
    Join Date
    01-30-2020
    Location
    Mpls., MN
    MS-Off Ver
    Office 365 (Excel 2016)
    Posts
    4

    Help with VBA for Date Change Macro

    Hi, my team has a spreadsheet of projects that we use to track status. I've created a macro, but it has errors because I'm very new to VBA. The macro needs to change the status of a project when a date becomes 7 days old or older.

    Created Date is in Column B
    Status is in Column C

    This is the code I have so far. Can someone please help?
    Please Login or Register  to view this content.
    Last edited by graciegables; 01-30-2020 at 02:42 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,175

    Re: Help with VBA for Date Change Macro

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,175

    Re: Help with VBA for Date Change Macro

    Try this:

    Please Login or Register  to view this content.
    Last edited by alansidman; 01-30-2020 at 01:19 PM.

  4. #4
    Registered User
    Join Date
    01-30-2020
    Location
    Mpls., MN
    MS-Off Ver
    Office 365 (Excel 2016)
    Posts
    4

    Re: Help with VBA for Date Change Macro

    Thank you so much! It worked! I don't understand most of what you wrote though. Is there a site you could recommend that would help me learn VBA better and the terminology?

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,175

    Re: Help with VBA for Date Change Macro

    https://www.google.com/search?q=Lear...hrome&ie=UTF-8




    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change code so macro activates when entry date is older or equal to current date
    By Big.Moe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2017, 10:59 PM
  2. [SOLVED] Macro to change text date into normal date
    By mark888 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-20-2017, 03:59 AM
  3. Different colour for Date Changes & Date Change Macro Command
    By jon112211 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-12-2015, 02:35 AM
  4. Cell change --> date change macro
    By K3mp3r in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-07-2014, 05:31 AM
  5. Macro: Help, Need Macro, Change Color, Open File, Restart at date
    By fastfire in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 05:52 PM
  6. Macro to Change color of cell after cross referencing date with a given date.
    By liajet24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2013, 12:33 PM
  7. Macro to change date to next day.
    By Djanvk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2008, 12:35 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1