View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hennie Neuhoff Hennie Neuhoff is offline
external usenet poster
 
Posts: 57
Default Format Msgbox - time HH:mm

I want the messagebox to display the time formatted hh:mm
I've played around with the following, without any joy!
msgbox "The starting time is:" & Val(Range("stime")) & Format (stime,"hh:mm")
Where do I go wrong?
--
HJN