Time Entry

A simple problem I would appreciate your help with.

I have a work sheet with several cells where time is to be entered in the
format hh:mm. Unfortunately a lot of users are enetering it in the format
hh.mm.
Is there any way I can automatically convert to the right format, or not
accept the (.) but only (:).

Thanks for your help.


0
6/12/2005 8:21:58 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
705 Views

Similar Articles

[PageSpeed] 41

Private Sub Worksheet_Change(ByVal Target As Range)

If InStr(1, Target.Text, ":", vbTextCompare) < 1 Then
MsgBox "invalid entry"
End If

End Sub


Enter the above code in the sheets module



Mangesh


-- 
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10470
View this thread: http://www.excelforum.com/showthread.php?threadid=378378

0
6/12/2005 9:22:58 AM
Reply:

Similar Artilces: