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