MS Access 2003 - Embedded Excel Spreadsheet on Access form

Posted by Justin on Stack Overflow See other posts from Stack Overflow or by Justin
Published on 2010-03-29T22:26:36Z Indexed on 2010/03/29 22:33 UTC
Read the original article Hit count: 635

lets say I have an embedded Excel Spreadsheet on a Microsoft Access form. I call the object frame

ExcelFrame

and I add a text box on the form called

txtA1

and I add a button on the form called

cmdInsert

I want to type "Hello World" into the text box, click the button and have it appear in the A1 cell on that spreadsheet. What VBA do I use to accomplish this?

Thanks

© Stack Overflow or respective owner

Related posts about ms-access-2003

Related posts about excel-vba