Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can you draw a shape when the values change each time??
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can you draw a shape when the values change each time??
See example with worksheet Change event proc: http://cjoint.com/?erkFfzkxwN
HTH -- AP '-------------- Private Sub Worksheet_Change(ByVal Target As Range) If Intersect( _ Target, _ Union( _ Range("Center_X"), _ Range("Center_Y"), _ Range("Radius") _ ) _ ) Is Nothing Then Exit Sub With Me.Shapes("Circle1") .Top = Range("Center_Y").Value - Range("Radius").Value .Left = Range("Center_X").Value - Range("Radius").Value .Height = 2 * Range("Radius").Value .Width = .Height End With End Sub '--------------- "man57" a écrit dans le message de ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a formula change a cells colour after a given length of time? | Excel Worksheet Functions | |||
Fun with Time values | Excel Discussion (Misc queries) | |||
can excel draw a shape based on values entered in cells | Excel Worksheet Functions | |||
Time Stamp without change | Excel Discussion (Misc queries) | |||
Time Stamp-With Change | Excel Discussion (Misc queries) |