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

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

It isn't going to be the time that the user is using the form. In fact it
just needs to be a regular clock or have all the options (like a drop down,
but I didn't want to put in every minute of a day in a drop down box). I was
looking for something like the calendar (a clock) to pop up so that the user
could click on the time that they came to work, time that they went to lunch
& time they left.
--
ldd


"mikelee101" wrote:

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