Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel in a Form

Status
Not open for further replies.

chiuso2

MIS
Feb 22, 2002
58
Well, please try to understand what i'm going to ask you, because i'm not writing in my language..
I would like have an excel spreadsheet into a form, active when i open the form. Is possible, with an event Onclick
programmed on the spreadsheet, update a text box in the form with the active cell value in the spreadsheet??
If yes, please drive me in the right direction!
Thanks in advance
Mario.....Italy

 
Hi Mario
When I have done this in the past I used the Insert Object then From File in form design mode. Then you need some code to enable and unlock the spreadsheet.

Ciao Mario
Quando io ho fatto questo nel passato io usai poi l'Oggetto di Inserto Da Archivio in maniera di disegno di forma. Poi Lei ha bisogno di alcuno codice abilitare ed aprire il foglio di calcolo elettronico.

Me.OLEUnbound0.Enabled = True
Me.OLEUnbound0.Locked = False
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top