Loop Clear Text Boxes

I don't mean to insult you, but what is here is so wrong that I can't tell how to correct it.

Please give the following information:

What are these textboxes on--a worksheet, or a UserForm?
Are these ActiveX or Forms textboxes?
Are there six the textboxes you want to clear (plus one combobox)? I can't sort out why are you iterating 4 times.

Why not just

Please Login or Register  to view this content.

and then

Please Login or Register  to view this content.

This will clear all, unless there are some you don't want cleared?

If you want to loop through textboxes to clear them then use this code. This will loop through Textbox1 to TextBox4 and clear them.

Please Login or Register  to view this content.

Originally Posted by Johnny0811

They are mixture of textboxes and combo boxes on a userform.

They are named:

cmb_PackF_Level1
cmb_PackF_Level2
cmb_PackF_Level3
cmb_PackF_Level4

txtPackFQty1
txtPackFQty2
txtPackFQty3
txtPackFQty4

etc

I just wanted to tidy up my code, instead of having to repeat that same block of code 4 times.

So I guess this would work for the first instance....i.e cmb_PackF_Level

Please Login or Register  to view this content.

And so on until you put all 4 names in

Please Login or Register  to view this content.