Hello all,

I have inherited a set of Excel files from my predecessor. The file was originally a single Excel workbook with a number of sheets that made up a form for users to fill in, either directly into cells or text boxes. There is a final sheet that consolidates the data collected in the cells, but not the text boxes. Users have returned these forms with their data and I now need to consolidate the information and retrieve the data out of these files.

I am a new user of macros in Excel, but I fudged together a macro that I can run on an empty, open Excel doc, that:
- asks for which file I want to open
- gets the worksheet called 'Data' and copies and pastes it into open active workbook
- closes the file I grabbed the data from

This covers all of the data that was entered into the cells. But I also want to populate some of the cells in the new workbook with the text from the text boxes. So in the end I will have a summary of all of the data on a single sheet for each user. However, I am having issues finding any solutions online for how to gather the information from a text box successfully.

This is the code I have so far:

Please Login or Register  to view this content.
Ideally I was hoping to add some additional code underneath the line of code that copies and data into the new sheet. I tried adding:

Please Login or Register  to view this content.
Which I thought would put the text in the text box into J3, similar to the line of code above it. But it returns the error: Run-time error '438': Object doesn't support this property or method.

I know I am probably making a logical error with how macros work, but I am not familiar enough to see the problem. When searching for a solution it does seem like it should be easy to get the text from a text box into a cell with TextBox.Value, but I can't seem to get it to work.

Any advice you have would be greatly appreciated. Many thanks.