Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can excel draw a shape based on values entered in cells
I want to draw a rectangle which is sized by measurements entered on a
different sheet |
#2
|
|||
|
|||
Assuming you have a rectangle named "Rectangle 1" on worksheet 1, and
your size data is contained on worksheet 2, you could enter the following code which would size the shape object upon clicking a command button. Private Sub cmdProcess_Click() ActiveSheet.Shapes("rectangle 1").Width = Worksheets("Sheet2").Range("a1") ActiveSheet.Shapes("rectangle 1").Height = Worksheets("Sheet2").Range("b1") ActiveSheet.Shapes("rectangle 1").Left = Worksheets("Sheet2").Range("c1") ActiveSheet.Shapes("rectangle 1").Top = Worksheets("Sheet2").Range("d1") End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions | |||
how do i get excel to automatically compute cell values | Excel Discussion (Misc queries) | |||
hitting spacebar in excel deletes last character entered. | New Users to Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
How do I easily draw in Excel the Upper and Lower limits of a con. | Charts and Charting in Excel |