Lock character during entry in UserForm textbox

**Nu2Java** · 11-03-2012, 08:01 PM

Hi,

I am using a textbox in a userform to enter time and I want to reduce errors and reduce time to make entries and I was wondering if there is a way to lock the colon between numbers.

The user will be entering 2 digits for minutes and 2 digits for seconds. What I would like to do is automate the entry a little bit and have the colon placed in the textbox for them after the first one or two digits. How can this be done?

I have tried:

Please Login or Register  to view this content.

But this just fills the textbox up with a bunch of colons.... "::::::::::::::::::::::::::::::::::::::::::::::::::::::::::"
Thanks for any help!

**Norie** · 11-03-2012, 08:33 PM

You need add the colon after the first 2 characters, so check for when 2 characters have been entered.

Please Login or Register  to view this content.

**Winon** · 11-04-2012, 04:58 AM

Hello Nu2Java,

Try it like this with the AfterUpdate Event.

Please Login or Register  to view this content.

Assuming you are using military time, that would handle a situation where a user enters 730, instead of 0730.

Also see the "Please consider" note at the bottom of this post.

**Nu2Java** · 11-04-2012, 02:40 PM

Thanks Norie & Winon

Norie, thanks for the code. I realized the mistake I made with ">= 1" .... DOH! I went with Winon's code so I can have the user enter 1 or 2 digits for the minutes and it will enter 0 if not a 2 digit number which works great. I want to thank both of you for your time and help, it is very much appreciated.