Have Past due and Overdue show on the second and third box

Hello there Experts Exchange community i am trying to have this file do the following.

AA. By default it will not show the task that are not taken care of, but when there is ether a (PAST DUE) OR A (OVERDUE) a button will be shown on the side of the memo box called (OVER-MODE) in "RED" colored.

A. Because it is (OVERDUE) AND (PAST DUE) have it show up as follow for
(OVERDUE) have it show on the second box
(PAST DUE) have it show on the third box

B. Have both of them show up with it being underlined.

C. Have the (OVER-MODE) on red all up till all the OVERDUE/PASTDUE are taken care of.

D. If i click on it the function will show the OVERDUE/PASTDUE and if i click on it one more time it will
disable it from it showing the OVERDUE/PASTUDE but will remain in red because there are ether one or more of ether
OVERDUE/PASTDUE that are not taken care of.

1st.png
2nd.png
Omar is the password for the file... Thanks again Expert Exchange Helpers.
28981182.xlsm
Omar HernandezAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Martin LissConnect With a Mentor Older than dirtCommented:
Here is everything except the OVER-MODE code because I still don't understand the requirements for it. What I need are "before" and "after" pictures of what happens when you press the OVER-MODE button, but if you don't mind I'd like to do that in a new question because I spent a lot of time on this one.

Included in this release are:
o  Added code to handle past due and ovverdue items
o Fixed a bug where clicking the "Windows" button and choosing just 2 sheets including the GENERAL sheet would show all three.
o Removed the "NUM is completed" Msgbox
o Commented out the unneeded sort of the table on the GENERAL sheet
o Froze the top rows of the GENERAL sheet so that they will always be visible. If you don't like it, it's easy to undo.
o Speeded up the refresh code a bit by reducing the lookup range from 1048576 rows to the length of the table (about 100 rows)
o Corrected some spacing problems in the Every Now & Then and Must Do reports.
28981259.xlsm
0
 
Martin LissOlder than dirtCommented:
Please describe what column or shape you mean when you say "click on it the function".
We don't show "(PAST DUE)" anywhere so I'm confused about that.
And what is OVER-MODE?

There's also a question from our last thread about about the NUM button that you didn't answer.
0
 
Omar HernandezAuthor Commented:
Please describe what column or shape you mean when you say "click on it the function".
---The box in red inside the Comment area on the "to do summary" page

We don't show "(PAST DUE)" anywhere so I'm confused about that.
---PAST DUE is on the "J" column when days has past the given date.

And what is OVER-MODE?
---Nothing special only a name i gave the square on the comment area on the "to do do summary" page


There's also a question from our last thread about about the NUM button that you didn't answer.
Another small question; do you still want the "Num" button to display "Number is Completed" when it's done?
---It is a good suggestion, but i believe it won't be necessary because when i click on the Num Button when i click on reset button on that userform it will move it for a future day and it will show up on ----tomorrow--- or -----Future Days----- group.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Martin LissOlder than dirtCommented:
In the picture that you posted
????are you talking about column "J" or are you talking about the shapes? If it's the latter then that's not possible.

In the "Every Now and Then" shape you show things like "OVERDUE-6" underlined. I think it would look better if instead it was just the date it was due underlined because it would then line up with all the rest.
0
 
Omar HernandezAuthor Commented:
are you talking about column "J" or are you talking about the shapes? If it's the latter then that's not possible.
---I am talking about the button located on the comment box on (to do summary) page.

In the "Every Now and Then" shape you show things like "OVERDUE-6" underlined. I think it would look better if instead it was just the date it was due underlined because it would then line up with all the rest.

---Date sounds good
0
 
Martin LissOlder than dirtCommented:
Thanks, I'll get started now.
0
 
Martin LissOlder than dirtCommented:
I've noticed a problem with the Num function and columns "A" and "B". When you select a cell in one of those columns, the calendar only pops up if the cell is formatted as a date and in those columns some cells are dates and some are not. The problem is that when you select another cell in a row where column "B" is not formatted as a date, the Num function updates what's in column "L" but column "K" doesn't change.

What do you want to do about that?

I also found that the refresh function was doing a lot of sorting based (I think) on a column called "DONE". I assume you don't need that any more. Do you still need the sort?
0
 
Omar HernandezAuthor Commented:
The problem is that when you select another cell in a row where column "B" is not formatted as a date, the Num function updates what's in column "L" but column "K" doesn't change.

---I see, even if on column "A" or "B" the cell selected is not format in the way when using the pop up calendar ignore it and have it only working with those that are input on those column as follow with date

MM/DD/YY
0
 
Martin LissOlder than dirtCommented:
Why not format all of column A and B as date except for the rows with a single-digit value in column J which seems to indicate that it's a header?

And you didn't answer this question.
I also found that the refresh function was doing a lot of sorting based (I think) on a column called "DONE". I assume you don't need that any more. Do you still need the sort?
0
 
Omar HernandezAuthor Commented:
Why not format all of column A and B as date except for the rows with a single-digit value in column J which seems to indicate that it's a header?

---Sound's good

I also found that the refresh function was doing a lot of sorting based (I think) on a column called "DONE". I assume you don't need that any more. Do you still need the sort?

---We will be still needing the done button but it will be dealt with for a new question for today or if not around the middle of Dec, reason you already know my friend.
0
 
Martin LissOlder than dirtCommented:
For now at least I'll comment out the sort since it's not done very efficiently, and if we still need it I'll put it back in.
0
 
Omar HernandezAuthor Commented:
Sounds good
0
 
Omar HernandezAuthor Commented:
Got back from training, checked out the question answered and it is working supper, thanks again Martin Liss
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.