Macros, VBA, Excel Automation, etc.
by 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
-
jsoros60
- Rookie
-
- Posts: 2
- Joined: Mar 29, 2017
- Reputation: 0
- Excel Version: 2007
by 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.
-
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: No registered users and 10 guests