Does anyone have code that I can look at that would help me in manipulating a Text Box Shape in an Excel Spreadsheet? What I have to do is update some Excel Spreadsheets with VFP data. One section in the Spreadsheet is a Shape Text Box. I need to know how to clear the contents inside that text box. Then update it with a few VFP memo fields. Then format a few lines inside the text box for underlining. Also, I need to know how many rows are being taken up by the text box when I insert my Memo field data. So as not to go over the page size limit set up. So if say I enter text into the text box and it wraps so that the text goes past row 45, I need to know it.

Any help would be appreciated.

TIA