Home > Excel Tutorial > Frame Lengthening & Shortening Effect

Frame Lengthening & Shortening Effect

Frame Lengthening And Shortening Effect With Vba Loop

The loops were used purpose of lengthening / shortening frame ,stopping operation.It was a nice effect

For example ; extension loop codes :

Private Sub CommandButton1_Click()
Dim i As Double
Cancel = False
i = Frame1.Height
    Do
        i = i + 0.015
        Frame1.Height = i
                 If Cancel Then
                Exit Do
            End If
        DoEvents
        Loop Until Frame1.Height >= 276
End Sub

Visit Here To Download Template

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: