Sorry for the crosspost (also in microsoft.public.excel), but my multi-post
didn't work.

I've got an Access application in which I have a routine to build a visual
representation of several project timelines on an Excel spreadsheet.

I'm putting the months in Row 1, days of the month in row 2 (columnwidth=2),
and on each successive row, I'm adding a description in Column 1, and several
shapes that depict:
1. a line depicting the span of the project
2. several boxes depicting interim events along the project timeline
3. a textbox that describes each of these events

I have two questions:
a. Is there a way to add a control tip or something like that so that when
I mouse over one of the shapes (#1 or #2 above), it displays some details
associated with that shape? Maybe even a comment associated with the shape.
If so, how would I do this via code
b. Is there a way to "autofit" the textbox (#3 above)? When I build the
textbox, it currently has the same width as the shape it is associated with
(#1 or #2). But I would like to get it to grow or shrink to the appropriate
width (all on one line). How would I do this programmatically?

----
HTH
Dale