Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-11-05
14
Medium Priority
?
78 Views
Last Modified: 2016-12-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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
14 Comments
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41875718
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
ID: 41875722
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 49

Expert Comment

by:Martin Liss
ID: 41875727
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:Omar Hernandez
ID: 41875735
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 49

Expert Comment

by:Martin Liss
ID: 41875738
Thanks, I'll get started now.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41876206
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
 

Author Comment

by:Omar Hernandez
ID: 41876343
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 49

Expert Comment

by:Martin Liss
ID: 41876347
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
ID: 41876360
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 49

Expert Comment

by:Martin Liss
ID: 41876380
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
ID: 41876393
Sounds good
0
 
LVL 49

Accepted Solution

by:
Martin Liss earned 2000 total points (awarded by participants)
ID: 41877989
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
 

Author Comment

by:Omar Hernandez
ID: 41938306
Got back from training, checked out the question answered and it is working supper, thanks again Martin Liss
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

715 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