I want to loop an if statement so different textboxes in userform are included

Hi,

This is my first post and I'm a complete novice.

I'm looking for help with the code I'm writing and I'm sure there's a way to streamline it but I don't know how.

I have an if statement that checks specific textboxes in a userform (in the example below, the textbox names are "OneBedOneBNum" and "OneBedOneBArea") and depending on if they contain data or not, a message box is displayed or the data is transferred to a worksheet.

Is there a way I can loop this code so that after running for the "OneBedOneBNum" and "OneBedOneBArea" textboxes, they're replaced with a list of other textboxes in the userform with names "TwoBedOneBNum" and "TwoBedOneBArea", "ThreeBedOneBNum" and "ThreeBedOneBArea" etc.?

Would I have to change the textbox names to do this, or can I list them out for iterative replacement in the code?

I only have 13 textboxes to do this with but I feel like learning how to do the best way other than tedious copy and pasting and writing out all the names will be beneficial in the future.

Below is the code I'm talking about (note that "Accom" and "Htg" are the worksheet names):

Please Login or Register  to view this content.

Many thanks,

Jack

Thanks for taking the time to look at my query and respond. I'm sorry I don't quite understand how I can use the function, I'll elaborate a bit and hopefully you might be able to steer me in the right direction?

That's pretty much right re: copy/pasting the block of code and changing fieldnames within it. I'll need to copy and paste the code and change the fieldnames (corresponding with the textbox names in the user form), MsgBox contents (corresponding with labels in the user form) and increase the row number by 1 in the excel sheet where the data is pasted. I've pasted three blocks of code below to show what what I need to change, and a picture of user form is that helps. Can this be streamlined with a function?

Please Login or Register  to view this content.

Attachment 795204