I'm after a bit of VBA to do the following:-
I need to extract text which has been entered into a Text Box on an Excel sheet and write it into a cell.
Also on the same sheet are rectangles in which text has been written. I also need to extract this and write it to a cell.
The reason for this is a badly designed spreadsheet (not mine)which was mailed to hundreds of people for them to fill in some comments. I now have been asked to collate the results.
Many thanks in advance...