I have 19 users capturing data on excel.
With Visual Basic and the calendar control, I created a touch calendar to
insert new dates. Now I want to use something similar to capture TIME - a
little watch or something they can just click on when the cell is activated.
No manual typing required. Can you help me?

Choose a picture of a watch/clock from INsert Picture ClipArt Office,
then assign the following macro to it.........

Sub TimeStamp()
ActiveCell.Value = Time
End Sub


hth
Vaya con Dios,
Chuck, CABGx3


"Ronel" wrote:

I have 19 users capturing data on excel.
With Visual Basic and the calendar control, I created a touch calendar to
insert new dates. Now I want to use something similar to capture TIME - a
little watch or something they can just click on when the cell is activated.
No manual typing required. Can you help me?

If I insert a picture of a watch/clock, my user cannot change the time and I
want them to be able to change the watch times.

"CLR" wrote:

Choose a picture of a watch/clock from INsert Picture ClipArt Office,
then assign the following macro to it.........

Sub TimeStamp()
ActiveCell.Value = Time
End Sub


hth
Vaya con Dios,
Chuck, CABGx3


"Ronel" wrote:

I have 19 users capturing data on excel.
With Visual Basic and the calendar control, I created a touch calendar to
insert new dates. Now I want to use something similar to capture TIME - a
little watch or something they can just click on when the cell is activated.
No manual typing required. Can you help me?