New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Add days count

Macros, VBA, Excel Automation, etc.

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: Google [Bot] and 64 guests