Closed Thread
Results 1 to 3 of 3

splash screen

  1. #1
    animated text in excel workshe
    Guest

    splash screen

    is there a way to animate text in a cell in an excel worksheet?

  2. #2
    ben
    Guest

    RE: splash screen

    ok, a little more detailed, what exactly do you mean by animate?

    "animated text in excel worksheet" wrote:

    > is there a way to animate text in a cell in an excel worksheet?


  3. #3
    Todd Huttenstine
    Guest

    splash screen

    below is some sample code. I use this to animate
    wordart. You may be able to apply this to some graphic
    file.

    Private Sub Worksheet_Activate()
    On Error Resume Next

    Set OldCell = ActiveCell
    ActiveSheet.Shapes("WordArt 1").Select
    m = 1
    For i = 1 To 10
    Selection.ShapeRange.TextEffect.Tracking = m
    m = m + 0.25
    DoEvents
    Next i
    For i = 10 To 1 Step -1
    Selection.ShapeRange.TextEffect.Tracking = m
    m = m - 0.25
    DoEvents
    Next i
    Selection.ShapeRange.TextEffect.Tracking = 1

    ActiveSheet.Shapes("WordArt 2").Select
    For i = 1 To 8
    Selection.ShapeRange.IncrementRotation 90
    DoEvents
    Next i
    OldCell.Select
    End Sub


    >-----Original Message-----
    >is there a way to animate text in a cell in an excel

    worksheet?
    >.
    >


Closed 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