Solved

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

Posted on 2016-11-05
13
33 Views
Last Modified: 2016-11-26
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
0
Comment
Question by:Omar Hernandez
  • 7
  • 5
13 Comments
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
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
 

Author Comment

by:Omar Hernandez
Comment Utility
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
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
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
 

Author Comment

by:Omar Hernandez
Comment Utility
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
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
Thanks, I'll get started now.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:Omar Hernandez
Comment Utility
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
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
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
 

Author Comment

by:Omar Hernandez
Comment Utility
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
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
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
 

Author Comment

by:Omar Hernandez
Comment Utility
Sounds good
0
 
LVL 45

Accepted Solution

by:
Martin Liss earned 500 total points (awarded by participants)
Comment Utility
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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now