possibility of automatically placing an autoshape using a function
 

what I have is some data tables on sheet2 containing proper date format
and on sheet 1 i have dates (sort of, not in any strict format lik
mm/dd/yy) going down the left and various columns. what i need is t
place an autoshape in the correct place on sheet1 roughly under th
correct date and column. I will need to place smallish diamonds, an
bubbles, and i will need the bubbles text filled with the date from th
datasheet.

I also need the position of these shapes to automatically change if th
date in the data table changes (basicaly i am drawing a chart based o
these dates and the dates are subject to change quite often so it
irritating having to manually re-draw all the shapes).

i dont have much vba experience.

does anyone know if its even possible to put autoshapes in specifie
places in an excel sheet

--
Message posted from http://www.ExcelForum.com

possibility of automatically placing an autoshape using a function
 

neowok,
It sound like you need look into the WorkSheet_Change event to trigger an
update of shape positions, VLookUp to find which date value you should be
inserting and Shapes collection.
Easiest way to give you an idea is Record New Macro, add a shape, position &
size it, change text etc, then see what code VB has generated.

Nick

"neowok " wrote in message
...
what I have is some data tables on sheet2 containing proper date format,
and on sheet 1 i have dates (sort of, not in any strict format like
mm/dd/yy) going down the left and various columns. what i need is to
place an autoshape in the correct place on sheet1 roughly under the
correct date and column. I will need to place smallish diamonds, and
bubbles, and i will need the bubbles text filled with the date from the
datasheet.

I also need the position of these shapes to automatically change if the
date in the data table changes (basicaly i am drawing a chart based on
these dates and the dates are subject to change quite often so its
irritating having to manually re-draw all the shapes).

i dont have much vba experience.

does anyone know if its even possible to put autoshapes in specified
places in an excel sheet?


---
Message posted from http://www.ExcelForum.com/