possibility of automatically placing an autoshape using a function

[neowok]

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

 

[Nick Cranham]

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