In my userform, I have two textboxes that are formatted to "HH:MM AM/PM" on a 12 hours clock after the user enters time in military time (24 hour clock). But now I'm trying to make sure the 2nd textbox isnt earlier than the 1st textbox. I've been tinkering around with the Exit event and simply comparing their .values in an if statement, but I dont think its working properly. I intuitively feel like I need to have some sort of format call to properly compare the values. The code is below. The commented out portion is whats giving me trouble. I know it looks like a 5 year old coded this; Im just a mechanical engineer, not a computer scientist. Thanks for any input!
Bookmarks