Recent content by jz75455

  1. J

    Email sent excel multiple cell due dates

    Sorry, Link. https://forums.techguy.org/threads/how-do-i-get-this-code-to-stop-emails-of-the-cell-next-to-it-is-marked-complete.1164278/https://forums.techguy.org/threads/how-do-i-get-this-code-to-stop-emails-of-the-cell-next-to-it-is-marked-complete.1164278/
  2. J

    Email sent excel multiple cell due dates

    I am asking the same question but, have not had a response. I found some code that you could alter if you know anything about VB. I don't. Look at my thread, it might help you.
  3. J

    Are there members that freelance? Am I allowed to ask that?

    I have a project that I need to complete and am freaking out because I can not figure out the VB code. I need excel to email certain individuals the day a task is due and keep sending emails until a box next to the cell is marked completed. I would rather trade services, not rich, but I am...
  4. J

    How do I get this code to stop emails of the cell next to it is marked complete

    I found this code, I can make it work but how do I get it to stop emails of the cell next to it is marked a completed or to keep sending emails until marked completed? Sub datesexcelvba() Dim myApp As Outlook.Application, mymail As Outlook.MailItem Dim mydate1 As Date Dim mydate2 As Long Dim...
  5. J

    How do I get this code to stop emails of the cell next to it is marked complete

    Any advise on how to get the sheet to send emails on multiple dates and to continue to send them everyday until the cell next to it is checked completed?
  6. J

    How do I get this code to stop emails of the cell next to it is marked complete

    Used in sheet Use conditional formatting and add two rules for 2007, 2010 or 2013 excel version Conditional Formatting Highlight applicable range >> J6 Home Tab >> Styles >> Conditional Formatting New Rule >> Use a formula to determine which cells to format Edit the Rule Description...
  7. J

    How do I get this code to stop emails of the cell next to it is marked complete

    Here is an updated version of the spreadsheet. I just need to figure out how to get it to email.
  8. J

    Solved Dropdown Menu text selected, highlights other cell

    Wayne, Thank you!!!!!!!!!!!!
  9. J

    Solved Dropdown Menu text selected, highlights other cell

    Cell K6 is a dropdown menu with Incomplete & Completed as choices and if Incomplete is selected, Cell J6 is highlighted red, If completed is selected, J6 is highlighted Green. Excel 2010
  10. J

    How do I get this code to stop emails of the cell next to it is marked complete

    I have made some changes, added new formulas. IS what I want even possible?
  11. J

    How do I get this code to stop emails of the cell next to it is marked complete

    Figured out this gem How to count text in a row of cells. =COUNTIF(AI3:AI400,"*Completed*")
  12. J

    How do I get this code to stop emails of the cell next to it is marked complete

    I am thinking I can copy the formula for each cell and day?
  13. J

    How do I get this code to stop emails of the cell next to it is marked complete

    I found this code in an excel spreadsheet that does sort of what I want it to do but, I don't now how to apply it to what I want. I can change the Email notice in the code, but how to get it to send an email to a specific person on a spefic day and to keep sending them until it has been...
  14. J

    How do I get this code to stop emails of the cell next to it is marked complete

    Please help if you can, I know very little about excel and I have a very complicated spreadsheet to build. If I can pull this off, it will help me fight the coming layoffs. Problem I need excel to send automatic email when the spread sheet is opened to the supervisor every time a check in...
Top