View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Automating the "Oval" Object

If I understand you
right click on the auto shape(oval) add textin the FORMULA bar type in =n3
where n3 is the first of your merged cells. Then when n3 is changed the text
will appear in the shape.

--
Don Guillett
SalesAid Software

"Phil Hageman" wrote in message
...
Is it possible to link text in the Oval object (from the Drawing toolbar)

with text in a merged cell range - the object being when a user types text
in one, it appears in the other? If so how would this be done?