New Excel Forum

This forum has been moved to

Ask all future questions in the New Excel Forum.


Add days count

Macros, VBA, Excel Automation, etc.

Add days count

Postby jsoros60 » Thu Apr 20, 2017 10:51 am


how can i add to the code below another line to counts days left/pass for the schedule event:

here is the code:
Code: Select all
For Each cell In Worksheets("TNW_TASK").Range("A4:A50")

If Date >= cell.Value - 3 Then

MsgBox "Hi Jose," & vbNewLine & "Today(" & Format(Date, "d/m/yy") & ")" & vbNewLine & _
"Name of the event : " & Worksheets("TNW_TASK").Range("C" & Range(cell.Address).Row).Text

End If


End Sub

  • 0

Posts: 2
Joined: Mar 29, 2017
Reputation: 0
Excel Version: 2007

Re: Add days count

Postby Don » Wed Apr 26, 2017 8:22 am

Read the message at the top of the page. New posts need to be made a in the forum there.
  • 0

Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 20 guests