Labeling shapes on a spreadsheet via VBA
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 |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com