I have 19 users typing in data.
The column TIME RECIEVED has to be entered.
The user must see a little watch when he touches the cell where time has to
go in and the time must then automatically go to the cell if the user moves
the watch.

hi Ronel ,
is this little watch a control within Excel , or is it something you created
?

MarMo

"Ronel" wrote in message
...
I have 19 users typing in data.
The column TIME RECIEVED has to be entered.
The user must see a little watch when he touches the cell where time has
to
go in and the time must then automatically go to the cell if the user
moves
the watch.

No. Like the dates and calendar control, I am looking for something similar
but with time not dates

"MarMo" wrote:

hi Ronel ,
is this little watch a control within Excel , or is it something you created
?

MarMo

"Ronel" wrote in message
...
I have 19 users typing in data.
The column TIME RECIEVED has to be entered.
The user must see a little watch when he touches the cell where time has
to
go in and the time must then automatically go to the cell if the user
moves
the watch.

Ronel ,
I've looked around a little bit.
check this site
http://www.experts-exchange.com/Appl..._21754771.html
and look for ee-1754771-userform-and-time.xls .
download it and see if you can get on with this one.
Personally i've added a button to this form to add the time in the
activecell.
If you want this adapted file , pls reply.
Hope this helped.
MarMo


"Ronel" wrote in message
...
No. Like the dates and calendar control, I am looking for something
similar
but with time not dates

"MarMo" wrote:

hi Ronel ,
is this little watch a control within Excel , or is it something you
created
?

MarMo

"Ronel" wrote in message
...
I have 19 users typing in data.
The column TIME RECIEVED has to be entered.
The user must see a little watch when he touches the cell where time
has
to
go in and the time must then automatically go to the cell if the user
moves
the watch.

Can I see your button file please. The website did not help. Sorry

"MarMo" wrote:

Ronel ,
I've looked around a little bit.
check this site
http://www.experts-exchange.com/Appl..._21754771.html
and look for ee-1754771-userform-and-time.xls .
download it and see if you can get on with this one.
Personally i've added a button to this form to add the time in the
activecell.
If you want this adapted file , pls reply.
Hope this helped.
MarMo


"Ronel" wrote in message
...
No. Like the dates and calendar control, I am looking for something
similar
but with time not dates

"MarMo" wrote:

hi Ronel ,
is this little watch a control within Excel , or is it something you
created
?

MarMo

"Ronel" wrote in message
...
I have 19 users typing in data.
The column TIME RECIEVED has to be entered.
The user must see a little watch when he touches the cell where time
has
to
go in and the time must then automatically go to the cell if the user
moves
the watch.