Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!
View Course

Add days count

Macros, VBA, Excel Automation, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

Add days count

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

Hi,

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

Next

End Sub



thanks
  • 0

jsoros60
Rookie
 
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 TeachExcel.com in the forum there.
  • 0

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


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Baidu [Spider] and 3 guests