+ Reply to Thread
Results 1 to 2 of 2

How can you draw a shape when the values change each time??

  1. #1
    man57
    Guest

    How can you draw a shape when the values change each time??



  2. #2
    Ardus Petus
    Guest

    Re: 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" <man57@discussions.microsoft.com> a écrit dans le message de
    news:6DB16118-BAF4-470F-90FB-91DA834D8384@microsoft.com...
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1