View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Datasort Datasort is offline
external usenet poster
 
Posts: 50
Default 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