Simplify blocks of conditional statements

I'm no VBA expert so take this with a dash of salt...but...

I would make an array variable with inserted values in multiples of two. So 9 textboxes would look like


if Textbox1 = "" then 2
if Textbox2 = "" then 4
if Textbox3= "" then 8
if Textbox4 = "" then 16
if Textbox5 = "" then 32
if Textbox6 = "" then 64
if Textbox7 = "" then 128
if Textbox8 = "" then 256
if Textbox9 = "" then 512


then sum the array in each if statement. then you know if the sum of the array is 192, the only possible reason is textbox 6 and 7 are blank and the rest are populated, so you can use that instead of the variation of textbox#.value <>/=""


You can build a legend easily in excel to figure out what the conditions would be:

Cells A1 through A10 represent Textbox1 through Textbox10
In B1 use the formula =2^ROW() and copy the formula down
In C1 through C10, put 1 or 0 to show the condition of blank textbox or not blank textbox (put a 0 when you want to see blank or 1 for not blank for example)
In D1 put =SUMPRODUCT(A1:A10,B1:B10) this will be your result


So now you can do something like:

Please Login or Register  to view this content.

with something like

Please Login or Register  to view this content.

it can be reduced down a bit quite easily however it may be more sensible to look at the 4 Subs you're calling. Are they wildly different to each other or could you not simply pass the required textbox values into there and incorporate the logic into one Sub?

Some of the changes I can see (or potential flaws in the logic) are:

All of the IF statements start with checking textbox1 isnt blank but a blank isnt possible as previous IF has taken care of those.

textboxes 5 and 9 are always required to be blank so you should probably check these in one IF statement and drop out then (probably do these as the 2nd IF statement). You can then remove those two from the other IFs to make them more readable.