Referncing objects in spreadsheet
If these are from the control toolbox toolbar, good luck (is right) on
addressing events for controls in a frame on a worksheet.
--
Regards,
Tom Ogilvy
"Datasort" wrote in message
...
try the change event of the textbox
Sub Tbox_AAA_Change()
cells (?,?) = TBox_AAA?.value
end sub
where AAA is the name of the textbox control
Good Luck
Stewart Rogers
"PO" wrote:
Hi!
I have inserted a frame object in a spreadsheet. Inside the frame I have
placed 5 textboxes. I want to link the textboxes text to a cell in the
spreadsheet.
For instance, formula in Cell A1:
=Frame1.Textbox1.Text
The above formula, of course, doesn't work. How do I do this?
TIA
PO
|