Return an error if text is inputted rather than a number

I wish my problem was as black and white as that, but there's a bit of grey area which is why I'm having trouble...

This is part of the code I have for a button I have on one of my spreadsheets. I ask the user to input a time. It can be 5 digits (hh:mm) AND must include a colon in the third place/digit, OR it can be blank.

I am trying to make this AS dummy proof as a I can for the folks who'll be using the tool it's attached to. So I am having trouble with integrating how to add code to make the error message box pop-up if the user inputs text (for ex. as:df). Any help would be greatly appreciated!

Please Login or Register  to view this content.

Looks good so far. I kept getting the Invalid Hours error if I tried to change the time, regardless of what I put in and it automatically changed to 23:mm? Is that just b/c the code is incomplete so far? Sorry I am still new to VBA!

I appreciate the help!

Hi BladeAP,

See the attached file which offers a couple of Options.

Try the following (tested and working):

Please Login or Register  to view this content.

Alternately, you could lock the Text Box, and use a couple of Spin Buttons to control the hours and minutes.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

Originally Posted by LJMetzger

Hi BladeAP,

See the attached file which offers a couple of Options.

Try the following (tested and working):

Please Login or Register  to view this content.

Alternately, you could lock the Text Box, and use a couple of Spin Buttons to control the hours and minutes.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

YES! The first option worked great! I'll look into Spin Buttons and declaring variables for future instances. Appreciate the help!

Originally Posted by mehmetcik

I am debugging at the moment.

Try the revised userform.

This version incorporates that improvement I spoke of.

Thanks! This code looks pretty neat, I will try it!