Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Blinking Button

hello everyone,
I would like to create a blinking button...What I have done
is....
================================================== ===========================

Sub blinking()

Dim X As Integer

x = 0

DD:
X = X + 1

If ActiveSheet.Buttons("Button 1").Text = "BUTTON 1" Then
Application.Wait Now + TimeValue("00:00:01")
ActiveSheet.Buttons("Button 1").Text = ""

ElseIf ActiveSheet.Buttons("Button 1").Text = "" Then
Application.Wait Now + TimeValue("00:00:01")
ActiveSheet.Buttons("Button 1").Text = "BUTTON 1"

End If

If X < 10 Then

GoTo DD

End If

End Sub

================================================== ===========
The problem is...this only limited to x=10..meaning its blinking
around 5 times..and during this time, i cant click on anything..i want
the loop to go on and on until user click on another button. something
like a interrupt request... is there any solution for this ?

regards,
Aisar
 
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
blinking cell ktisqj Excel Discussion (Misc queries) 5 September 9th 09 07:04 AM
Blinking text somaloft Excel Worksheet Functions 1 May 3rd 08 03:01 PM
Blinking Text Esra Dekan Excel Worksheet Functions 43 February 19th 08 12:42 AM
Blinking Cell Will Excel Discussion (Misc queries) 2 April 23rd 07 10:10 AM
blinking cell chiuinggum Excel Worksheet Functions 3 July 3rd 06 04:14 AM


All times are GMT +1. The time now is 12:41 AM.

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

About Us

"It's about Microsoft Excel"