Cancel Data Entry if text box is blank

I apologise if this is a repost but I have been searching for a while and cannot find a solution to my problem

I have created a userform in which there is a combo box and several text boxes these boxes input data into corresponding cells depending on the option selected in the combo box

the problem I have is that when a text box is blank the data is still input into the spreadsheet leaving that cell blank

I wish to write into the code that if a text box is blank the data entry is cancelled, focus is set onto that box and an error box comes up
I have included my code below to show what I have at the moment

Please Login or Register  to view this content.

where is your data entry code?

first

i suggest you set it to pre check textbox
what your code does is write all the outputs then check textbox
ie put the check for txtno at the start

Secondly
to your original question
put this at the start of the code

Please Login or Register  to view this content.

thirdly
may i suggest you use select/case instead of 12 If statements
as essentially you are just setting the outputs for the 12 months i presume

i'm only throwing suggestions at you which should make your life easier for coding in the future
you don't have to take on board if you are not comfortable with it or just want to leave it as is

pre-checking allows you check the condition of the text box prior doing the actual data entry

Please Login or Register  to view this content.

^^what this code does is
checks if txtno is blank...if it is has a popup message box and stops the code from continuing

the code isnt what i posted
you are missing the exit sub bit

i made a quick mock up of what i think you have setup
using your 12 if statements

bear in mind this only checks if txtNO is blank
none of the other textbox are checked

since i created it already

should you want to learn more about the suggestions i posted
i made the amendments i suggested on v2 button

it checks all textboxs and combobox to make sure they are not empty as well

then once you have learnt that method
version 3 the really clean and short method

Please Login or Register  to view this content.

i also made a subroutine to clear form which you can call from any of the buttons now
if you want me to explain any of it just let me know