novice123,

You can use the Worksheet_SelectionChange Event.

What is the sheetname?

What is the cell (A1, B10)?

What time format do you want displayed (hh:mm:ss, ...)?


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115152