Referncing objects in spreadsheet
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
|