Copy data from multiple txtboxes without listing name of each box in code

[Isaaq]

Hi All,

I have 5 userforms with hundreds of textboxes. The name i have given for each textbox already appears as a column heading in the wksheet where the data has to go. One way of transferring the data is to write out the name of each textbox in the code and refer it to the specific cell. As I have so many boxes this is going to take forever. Is there anyway of sending the data from each textbox to a particular cell if the textbox name, matches the column name.

Thanking you for time.

[romperstomper]

I have 5 userforms with hundreds of textboxes.

Ouch.

Is there anyway of sending the data from each textbox to a particular cell if the textbox name, matches the column name.

Assuming a range variable, rng, that refers to the column headers, and a row variable, lngRow, that indicates which row to output to, something like this in the userform:

Please Login or Register  to view this content.

[Andy Pope]

you should be able to make use of the controls collection of the userform

Please Login or Register  to view this content.

[Isaaq]

Thanks fellas