Excel 2007 -VB.NET - how do you create a textbox and input value from cell?

I have an Excel sheet that will have different information on the sheet everytime I open the file. Ex: Saving Excel sheet and overwriting file .

I have a macro that goes into the Excel Sheet and auto arranges the cells in an order that I can read the information more clearly...stacked rather than all in one row.

I need to export certain cell values over to a Word 2007 doc file for further use (auto populate a template letter).

What I am wanting to know is the first step in the many steps needed and I may be able to figure it out from there.

Let's say that I have a macro on the Excel sheet that will always be there...how can code the macro to create a textbox and input the value of cell A1 into the textbox after it's creation?

Thanks

Quote:

---

how can code the macro to create a textbox

---

a textbox where?
in word document?

I have an Excel document that I need to programmically create a textbox when I click a command button then take the value of cell A1 and put that value into the newly created textbox.

I will need to also need to export that value of the textbox in the Excel to a textbox already created into a Word document.

so

Excel - need to create a textbox programmically - take the value of cell A1 and put that value into the new textbox created in the Excel sheet.

Word 2007 - I have a textbox already created in my word document and I am needing to take the value of the Excel textbox just created and put the value from the Excel textbox1 and put the value into the Word textbox1.

Sorry if this is confusing but I don't really know how else to put it.