Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default splash screen

is there a way to animate text in a cell in an excel worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 260
Default 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?
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Splash Screen Brooke Excel Discussion (Misc queries) 5 March 25th 08 03:58 PM
splash screen K11ngy Excel Discussion (Misc queries) 3 July 9th 07 12:19 PM
splash screen Dave F Excel Discussion (Misc queries) 2 March 16th 07 05:00 PM
Splash screen and various screen resolutions George J Excel Programming 4 October 3rd 04 10:15 PM
VBA splash screen scott[_6_] Excel Programming 2 October 16th 03 09:27 AM


All times are GMT +1. The time now is 01:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"