Display constant time in textbox

I woul like to display the time in a textbox like a clock, where you can see the seconds counting.
Just like my watch.

textbox11=now() just gives the the time the form was opened and does not continue to count.

Any suggestion?

I think i need a OnCurrent event like in access.

Hello MikeWild2000,

Unfortunately VBA does not have a timer control like Visual Basic. You can create a Timer rather easily using the API. This is an interrupt driven timer like will update just like a clock. I have the code if you are interested. You can contact via private message or e-mail me at [email protected].

Sincerely,
Leith Ross

Hi Leith,

Thanks for your reply i found the answer at:

http://xcelfiles.homestead.com/API_02.html

Thanks again!