You could validate the input after they're done, though.
(grammar police)

Dave Peterson wrote:

I don't think so.

You could validate the input after their done, though.

Or maybe you could use two controls (one for the hours and one for the minutes).

Or even a time picker.
http://www.dailydoseofexcel.com/arch...3/time-picker/

Anthony wrote:

Hi,

Is there a way to 'force' a user to input the time on my userform in the
format xx:xx, ie 24hrs with ':' between the hours and minutes
for example......

12:23 is good
09:12 is good
8:15 is good
1223 is bad
0912 is bad
815 is bad

the txtbox for this on the userform are txttime and txtATA

if the wrong format is used I would ideally like a msgbox to appear to
advise wrong format used.

hope you can help
thanks


--

Dave Peterson

--

Dave Peterson