You could try building a form with a text field and then populate the field
at the OnLoad event with something like this:

num = Now() - Int(Now())
hr = num * 24
mn = (hr - Int(hr)) * 60

tme = Int(hr) & ":" & Int(Min)

It wouldn't "tick" like a clock, but should give the user the correct time
(based on their system clock) at the moment the form loaded. If you wanted
to get into seconds, you could add another layer. This would also be
military time. If you didn't want that, you could put something like

If hr 12 then hr = hr -12

in there, but then you'd need an AM/PM designator.

Don't know if that would work for what you want, but it might at least be a
starting place....

Good luck.
--
Mike Lee
McKinney,TX USA


"vblaradetrich1" wrote:

Is there such a thing as a pop up clock? I would like to have a point & click
option for users to have when entering their time on a timesheet.
I am new to Macro's but have been teaching myself & recently created the
pop-up-calendar for users to have access to in my personal.xls folder & even
saved it as an Add-in. (still not sure about everything that I am doing but
it's becoming clearer every day)
--
ldd