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