format time in messsage box
thanks for that it works fine
no not a typo, the message is part of a imputbox , and is used to give the
DUE time of a item with a imput option to put a reason why it was late
thanks
Rich
"NickHK" wrote:
Rich,
You would normally use :
Format(<Value,"hh:mm")
Also I assume the InputBox is a typo and you mean MsgBox
Maybe:
reg = MsgBox(Range(locatetrunk).Value & " Due On Site At :-" &
Format(Range(timedue).Value, "hh:mm"))
NickHK
"Rich" wrote in message
...
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
|