Time

R

Ronel

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?
 
C

CLR

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
 
R

Ronel

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.
 
Top