Excel Copy Text Box to cell
Posted on 2015-01-19
I'd like a sub routine to copy the text from a predetermined textbox into a cell on the current worksheet. The various textboxes will be on a separate worksheet.
1) There are several potential textbox choices, the textbox name will come from cell "b2". i.e. "RadiantText" or "InsulationText"
2) The contents of the textbox needs to be pasted into cell "d3"