Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format time in messsage box
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
format time in messsage box
Rich,
OK, I was just going by your subject line. NickHK "Rich" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
About form messsage | Excel Programming |