View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Automating the "Oval" Object

Select the oval

go to the formula bar

enter
=A1
and hit return.

change A1 to the upper left cell in the merged cell range.

--
Regards,
Tom Ogilvy

"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?