Conditional Formatting Forms

[dualhcsniatpac]

I have seen this on the net somewhere but I have been searching for the past 20 min and cant seem to find it again. I am looking to have my VBA code double check an input from my form. For example, when the form is submitted I want it to check all of the fields to see if they comply with the format that I want them .

Time will be in the format (military) - "0000 - 2400" Is the best way to do this by case??? (Is there a way to specify that the 2 last numbers must be between 00-59??)

Also what are the commands for taking someone back to the form itself. I was thinking about just a popup window.

Thanks any help will do

 

[dualhcsniatpac]

Bump for something?

This is kinda what I have so far and I dont even know if I am close or not.

If coverunit.Value = ""
    End Sub
Else
    ActiveCell.Offset(0, 2) = coverunit.Value