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 programmatically 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********************@comcast.com...
I understand that, but how do I reference the Excel control from Access.
Normally I would write some kind of statement like
worksheet1.Range(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********@nospam.com> wrote in message
news:AY****************@newsread3.news.atl.earthli nk.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********************@comcast.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