View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
david mcritchie david mcritchie is offline
external usenet poster
 
Posts: 691
Default "Comment" in an "Oval" ?

Hi Bob,
It is possible to put text into shapes. In fact a text box is a shape.
Bring up the Drawing toolbar, and select oval then draw the
oval on the worksheet by selecting the upper left hand corner
(of a containing rectangle) and drag the cursor to enlarge the
oval.

To populate with text. Right click on the border of of the oval,
insert text. If you don't have a hyperlink, the left click would
do the same - but I think it's better to use the rightclick.

There are no red mark associated with the oval.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Barnes" wrote in message ...
I am an Access Developer.

If you place an "Oval" on a Worksheet, you can also add text to it (but
the text displays constantly).

Is there a way to assign a "Comment" (like in a celll w/ the "red marks"
in the upper-left corner of the cell) so either clicking the Oval (or placing
the mouse over the Oval) would display a message?

TIA - Bob