View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default Format As TIME In A TextBox

Hey Harold,

Thanks for the reply. This works for current time entries. However,
I am entering times figures other then current time.

Is there a variant that will allow any time to be entered?

-Minitman



On Tue, 8 Feb 2005 22:52:13 +0100, "Harald Staff"
wrote:

TextBox1.Text = Format$(Now, "hh:mm AM/PM")

HTH. Best wishes Harald

"Minitman" skrev i melding
.. .
Greetings,

I have a TextBox which is loaded with a date when a UserForm is
opened. I can't get the TextBox to display the entry in a TIME format
(hh:mm AM/PM).

Any help would be appreciated.

TIA

-Minitman