Why not just use the actual time?

Textbox1.Text = format(now,"hh:mm")

--
Regards,
Tom Ogilvy

"James Auty" wrote in message
...
I am wanting to show a text box with time [formatted
hh:mm:ss] that updates every minute based upon a
counter. I have used the timer function for this that
works fine. However, I am using DateAdd to increment
this textbox by a minute but the formatting goes directly
to AM/PM format reather than the preferred 24 hr format.
This value is then copied to a cell along with other
stuff, etc.

Is there another way I canformat the textbox to show only
hh:mm:ss? I have tried using the Forat function but this
just throws up an error

Thanks

James