Is there any way to print the contents of a message box? If not, how can you print the contents of a Variable that contains
all the data of said message box?
Macro recorder isn't much help on this one.
I need to print the
contents of either the box, or the variable Z from the following:
Dim x As Range
Dim y As String
Dim z As String
y = "PEOPLE CURRENTLY OVERDUE FOR Training" & vbNewLine & vbNewLine
For Each x In Worksheets("Training").Range("OverdueCheck ")
If x.Value = "OVERDUE!" Then
y = y & x.Offset(0, -3).Value & " was due on " & x.Offset(0, -1).Value & vbNewLine
If y = "PEOPLE CURRENTLY OVERDUE FOR Training" Then
MsgBox ("Everyone is Current")
z = y & vbNewLine & vbNewLine & "They should be Scheduled as soon as possible"