Thread: Help with text box and time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kieran[_2_] Kieran[_2_] is offline
external usenet poster
  
Posts: 1
Default Help with text box and time

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