| 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 |
| 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 | |||
Threaded Mode
