Show filtered records in userform

Hi Clara

Welcome to the Forum...

When initially designing ones Form, one should always create the Text Boxes in order of the Column Headers within spreadsheets...
This way one can loop through textboxes and easily populate from Sheet...Col A vs TextBox1, Col B vs TextBox2 etc etc...
Ideally...I prefer keeping textbox names as default...once again allowing easy loop option...
Accordingly when writing back to sheet, one can easily resize range and populate at once without a loop...
By renaming the Textboxes, as you did, you started off by giving them the same names as Column Headers which could have worked if you did this for all the TextBoxes...sadly, this is not the case...You could then have looped TextBox controls and matched them with the Header names...

As you have just started, I suggest going back to the drawing board to amend to one of the following above suggestions...

If not, the only way I see this working is Storing all TextBox names in Array, All corresponding Columns in Array - same order as textboxes, and then loop and populate accordingly...

This will give you an idea...have changed first 4 columns of sheet and TextBoxes...

Please Login or Register  to view this content.

Check Torachan Posts...He has a few examples listed for members...