format time in messsage box
part of the code i am using in a macro is as follows
Dim timedue As String
timedue = "c" & rowAddress
reg = InputBox("" & Range(locatetrunk) & " Due On Site At :-" &
Range(timedue).NumberFormat = "hh:mm"& Chr$(13)
what i am hoping for is a way to display the "time" as a time in the message
box that appears when the macro is activated but cant find a way to "format"
the text
|