I am devoloping an Excel Workbook consisting of about 50 worksheets out of which 20 work sheets are for Data and 30 worksheets are for calculations of engineering Design.After completion of calculations I would like to generate a Drawing of the same(by utilising Excec Drawing tools) based on the input values given by me and the calculations done by the workbook in different worksheets.However at present Excel does not support formulas for drawing sketches.I have a fairly good idea of how to develop the same.I would like some body to help me by providing the Visual Basic code for Drawing the Following Basic figures to devolop the Drawing.
The program shall take index value(straightline-1,curve-2,text-3),and the following inputs given in a row of cells and draw the following.
1.Draw a straight line with following inputs[starting coordinates (in x,y cordinates in terms of Pixel position),length(in pixels),angle(in degrees),linestyle(continuous/dash),weight(1/4,1/2,3/4,1),colour(index no)].
2.Draw a Curve given the following inputs[center(in x,y coordinates in terms of pixel position),radius(in pixels),starting angle(in degrees),End angle(in degrees),linestyle(continuous/dash),weight(1/4.1/2,3/4,1),colour(indexno)].
3.Draw Text given the following inputs[Starting coordinates(in x,y coordinates in terms of Pixel position),String,orientation(vertical/horizantal),weight(1/4,1/2,3/4,1),colour(indexno)].
4.Enclose a group of basic figures drawn as above in one box and move as a group where ever i want.
5.Fill in the Enclosed figure with the colour specified.
I hope i have made my requirements clear.
D.S Rama Rao
Bookmarks