Sorry!
It's coming back to me slowly...
Those controls on Excel are quite difficult to reference externally.
(In fact, I think they're difficult to reference internally, too.)
The best I've done (AFICR) is to link your textbox (or checkbox) to an Excel
cell, then programmaticall y put the value in the cell.
If the control is big enough, you can "hide" the linked value in a cell
directly under it; otherwise you can use a separate sheet if you like.
HTH
"Mark C" <he******@yahoo .com> wrote in message
news:0u******** ************@co mcast.com...
I understand that, but how do I reference the Excel control from Access.
Normally I would write some kind of statement like
worksheet1.Rang e(A1).value = rst!fieldname.
If I try that with a control name I get an error. I am trying to find out
how to reference the Excel control in this line of code.
Mark
"MacDermott " <ma********@nos pam.com> wrote in message
news:AY******** ********@newsre ad3.news.atl.ea rthlink.net... You can use alt-F11 to display the VBE pane for your spreadsheet. There
are
two dropboxes at the top of the right-hand pane - the left-most one has
a list of all the objects (including text boxes and check boxes) on your
spreadsheet. You should be able to get the names of your objects from
there.
HTH
- Turtle
"Mark C" <he******@yahoo .com> wrote in message
news:Y6******** ************@co mcast.com... I currently have an Excel spreadsheet with numerous text boxes and
check boxes that I want to populate with data from an Access 97 database. I
have
used Excel automation in Access before but only to update cells not
controls like text boxes.
Can someone steer me onto the correct path? I am not using a VBA form
in Excel it is just merely various text boxes and checkboxes placed on a
worksheet.
Any help would be much appreciated.
Regards,
Mark