Referncing objects in spreadsheet

[PO]

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

 

[Guest]

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

 

[Tom Ogilvy]

If these are from the control toolbox toolbar, good luck (is right) on
addressing events for controls in a frame on a worksheet.