View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Krygim Krygim is offline
external usenet poster
 
Posts: 2
Default Reference to free-form textboxes

I insert a text box into Sheet1 of Excel and want to assign a value to this
text box via Excel automation from another program. I have tried the
following syntax without success:
oExcel.ActiveWorkbook.Sheets(1).Textboxes("TextBox 1").Value="Some
Text"

What is the correct syntax (or object path) to refer to this text box?

Thanks in advance.
KM