View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff
 
Posts: n/a
Default format textbox to time

Hi ASU

What do you want entry 12 to be ? 00:12 or 12:00 ? And what about 12.5 ? Is
it 12:30 or 12:50 ? (Believe me, your users will enter all kinds of crap so
prepare for absolutely every possibility)

Best wishes Harald

"ASU" skrev i melding
...
Need help on this one. How do I format a textbox, embeded in a userform,

so
that when I type the hour 2130 it displays 21:30.
--
ASU