+ Reply to Thread
Results 1 to 7 of 7

Change the content of a cell based on change the current date

  1. 04-13-2014, 04:40 PM #1
    aimanraya
    aimanraya is offline
    Registered User
    Join Date
    04-07-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2003
    Posts
    31

    Change the content of a cell based on change the current date

    All thanks to the excel forum Leaders , I want macro to sheet " gloos "
    Change the content of cell E2 based on the current date .
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-13-2014, 04:51 PM #2
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Change the content of a cell based on change the current date 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 04-13-2014, 04:59 PM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Change the content of a cell based on change the current date

    Hi,

    In the Workbook open event
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  4. 04-13-2014, 05:16 PM #4
    aimanraya
    aimanraya is offline
    Registered User
    Join Date
    04-07-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Change the content of a cell based on change the current date

    Thank you very much .
    Reply With QuoteRegister To Reply
  5. 04-13-2014, 06:00 PM #5
    aimanraya
    aimanraya is offline
    Registered User
    Join Date
    04-07-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Change the content of a cell based on change the current date

    Please, I want modified so that in the months before January (December) is the first semester , the months after January (February) is the second semester, This means that the month of December and January will be the first semester .
    Reply With QuoteRegister To Reply
  6. 04-14-2014, 03:49 AM #6
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Change the content of a cell based on change the current date

    Quote Originally Posted by aimanraya View Post
    Please, I want modified so that in the months before January (December) is the first semester , the months after January (February) is the second semester, This means that the month of December and January will be the first semester .
    Hi,

    That wasn't what you asked for in post #1.

    Instead therefore in the workbook open event again...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 04-14-2014, 07:07 AM #7
    aimanraya
    aimanraya is offline
    Registered User
    Join Date
    04-07-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Change the content of a cell based on change the current date

    Thanks for your help
    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)

Similar Threads

  1. If cell value's change , inserting current date
    By otacon23 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-09-2013, 09:52 AM
  2. Tab color change based on cell content
    By sammi8796 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-02-2011, 02:15 AM
  3. Change cell content based from another cell's content
    By RochesterColonial in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2010, 03:43 PM
  4. show current date and time when another cell change
    By herukuncahyono in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2010, 05:51 AM
  5. How to change a Macro based on content of a cell
    By Alex in forum Excel General
    Replies: 3
    Last Post: 05-15-2006, 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1