Referncing objects in spreadsheet
 

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

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

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