Thread: Help with text box and time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
D.S.[_3_] D.S.[_3_] is offline
external usenet poster
  
Posts: 60
Default Help with text box and time
Thanks Kieran,
that got me on the right track. The following code gave me the result I was looking for
txtTime = Format(Sheets("WRITEFORMDATA").Range("B22").Value, "HH:MM AMPM")


D.S.


"Kieran" wrote in message ...

Try this format option

txtTime = Format(Sheets("WRITEFORMDATA").Range("B22").Value, "HH:m")


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Reply With QuoteReply With Quote