+ Reply to Thread
Results 1 to 2 of 2

AutoSort by cell color and ole date to new date

  1. 09-14-2020, 04:04 AM #1
    indhrui
    indhrui is offline
    Registered User
    Join Date
    02-25-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    11

    Post AutoSort by cell color and ole date to new date

    Hi Friends,

    I am new to excel VB, i am trying to create auto sort by cell colour and expiry date when date saved or new data entered. i tried but i can't succeeded so please help me. I had attached the sample document.....
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-15-2020, 07:46 PM #2
    maniacb
    maniacb is offline
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: AutoSort by cell color and ole date to new date

    Try by adding this code to the Sheet1 module:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by maniacb; 09-15-2020 at 07:48 PM. Reason: Add file
    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. [SOLVED] Autosort all data by date when value in a column is filled
    By labfm5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2015, 04:10 PM
  2. Color cell if today date is bigger by 6 than reference date cell
    By alexxl in forum Excel General
    Replies: 2
    Last Post: 04-22-2015, 03:42 PM
  3. [SOLVED] VBA Macro to Color Row Text If Date in Cell is greater than system date
    By slick9456 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 06:09 PM
  4. 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
  5. Autosort by date AFTER formulas are updated
    By untern8 in forum Excel General
    Replies: 1
    Last Post: 01-17-2013, 07:19 PM
  6. European vs. American date formats messing up autosort
    By theradpotato in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-07-2010, 02:11 PM
  7. Autosort by date ...not alphabetically
    By Steve from SA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2008, 09:31 AM

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