Create a text box for each row of data and fill that textbox with concatenated cell value.

Hi all,

I have n number of rows in a table and n number of columns.

For each row I would like to create a unique textbox and the values of everything in that row being populated into that textbox.
I figured I could concatenate the row and get the information for the textbox from there.

Many thanks

Andy

That works perfectly, thank you Bishonen.

Hi,

I was wondering if the code above could be modified to create a dynamic link between the cells and the textboxes?

The code above creates a text box for each row in my table and populates that text box with values in a specific column.

Here are my changes so far:

Please Login or Register  to view this content.

As you can see I get the cell info from column C. For each row a unique textbox is created for that value from C.

Trouble is once the box has been created the only way to change the value inside is to manually edit it. As you can see there may be hundreds of text boxes and although I could simply run the routine again and create new boxes with the updated info I still need to locate the original box and delete it.

I's simply like to be able to make the changes in the table and have the corresponding textbox update automatically.

Any ideas?

thanks

Andy