Creating a Loop to check multiple textboxes and comobox

[Catsonheat]

Hi all,

I have a code which checks if the contents of a combobox match a textbox, if so, it checks to see if another text box is empty, and return a warning if it is. I have got this to work by creating IF statements for each individual check but thought there must be an easier way to do it using loops but have not been able to work out how to do it. My code is below, there are 8 textboxes in the first critera, and another 8 in the second, if combobox equals textbox 1 it checks textbox 9, if it equals textbox 2 it checks textbox 10 and so on, up to checking textbox 8 to check textbox 16 (as 1-8 is the first criteria and 9-16 is the second).

Any help would be greatly appreciated.

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[Catsonheat]

Hi Fluff, that worked perfectly, thank you! Rep added and marked thread as solved.

[Fluff13]

You're welcome & thanks for the feedback