Thread: Text Box help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
jayklmno jayklmno is offline
external usenet poster
 
Posts: 58
Default Text Box help

Both of these solutions work to create the text box where I want it, but in
order for me to have the box pull in the correct range, in this case a
formatted table,
I need to change the formula linked to the object...

which is normally
=EMBED("Forms.TextBox.1","")

to
=Liq_Table

The problem seems to be in the recorded code, once the object is created and
selected, Selection.Formula = "=Liq_Table" doesn't work.

Any suggestions?