Looping VB Macro Need a STOP Button 1

[Barneye]

I wrote a VB Macro to feed data from an Excel sheet to an ActiveX Control that runs an LED sign.


This Macro is on a loop. I made a button to start it, can I make one to stop it?

 

[CautionMP]

Barneye,
Yep. Declare a global variable ([tt]blnStop[/tt]?) and have your button set it's value to false. Then in your looping code add something like:

If blnStop Then
  blnStop = False
  Exit Sub 'or Function
End If

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[Barneye]

Great Thanks!