Userform problem with Textboxes and IF Statement

Good day Guys

This is my first post as a member (and a guy that just discovered forms) so my humble apologies if I am doing it wrong.

So here goes:

Ive got a Userform (Tax_Year_Details) that asks the User to select TAX YEAR DATE from a combobox(works perfect) and then to type opening odometer from a textbox1 and closing odometer from textbox2 and then finally total Business Kilometer in textbox4. All of these three textboxes are defined as

Please Login or Register  to view this content.

Once proceeding to click on the OK button it need to do a few checks and if there are errors a msgbox should give a describtion.

.... example Textbox2 can not be less in value than textbox1. E.G Opening reading is 5000km (textbox1) and Closing reading 4000km(textbox2) = msgbox " Closing is less than opening - Re-enter"
and
....example textbox3 can not be more than the difference of textbox2-textbox1. E.G. Traveled 2000km this year but opening reading was on 1000km and closing reading was on 1400km, = msgbox " Kilometers traveled is greater than kilometers from Opening and Closing specified"

Please Login or Register  to view this content.

Some times the values work sometimes it doesnt - Not sure why not. See attached pictures







Working Forum.png

Not Working Forum MSGBox.png

Not Working Forum MSGBox 2.png

Partly deleted while OP complied to Forum Rules.

Why not perform all tests (when OK-button pressed) before writing to Worksheet ?

Post example file with userform so we can test and adapt code.

I find that it is a lot easier to use one Macro to control all my textboxes.

Please Login or Register  to view this content.

This should do it.

You're welcome.