View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Rich is offline
external usenet poster
 
Posts: 298
Default 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