G
Guest
I have a public function where I am calculating time difference. Function is
working ok however I would like to display critical message after specific
time difference displaying critical message along with ticket number that
needs update
My function:
Dim interval As Double, str As String, days As Variant
Dim hours As String, Minutes As String, seconds As String
Dim smsg As String
smsg = " Please update Ticket: " & " " & [ticket#]
...............
MsgBox "Please update Issue: ", vbCritical, "Time for Update "
How can I pass correct ticket number to be display in this message.
With line: smsg = " Please update Ticket: " & " " & [ticket#]
I am getting error message [ticket#] -- External name no defined
I tried me.[ticket#] but i get invalid use of me keyword
Thanks
working ok however I would like to display critical message after specific
time difference displaying critical message along with ticket number that
needs update
My function:
Dim interval As Double, str As String, days As Variant
Dim hours As String, Minutes As String, seconds As String
Dim smsg As String
smsg = " Please update Ticket: " & " " & [ticket#]
...............
MsgBox "Please update Issue: ", vbCritical, "Time for Update "
How can I pass correct ticket number to be display in this message.
With line: smsg = " Please update Ticket: " & " " & [ticket#]
I am getting error message [ticket#] -- External name no defined
I tried me.[ticket#] but i get invalid use of me keyword
Thanks