Hi Tak,
Probably not exactly what you are looking for but, might spark new ideas to help solve your problem. (This method works perfectly for me).
I wanted a visual animation for my progress indicator (instead of the old bar type). As my macro downloads data, my little animation runs slowly enough to see everything.
I have a series of Character Map symbols on my sheet. The symbols are, 5-buildings, 1-mountain,1-sun, *1-airplane and 6-flames hidden by white font*). I use the following counter code to give the illusion that the airplane is swooping down (right to left) over the buildings and setting fire to each building one by one.
Private Sub CommandButton1_Click()
Count = 0
Do Until Count = 100
Count = Count + 1
[A1].Value = Count
Loop
MsgBox "Press OK to continue"
Range("A1").Select
ActiveCell.FormulaR1C1 = "0"
End Sub
When i push the CommnadButton this code starts. I have =IF(OR formulas on my sheet and Conditional Formatting (to add color) that will make the airplane appear in cell A20 when A1's value is between 1-10. Between, 11-20, the airplane appears in cell A21, 21-30, cell A22 and so on until 100. In this case i chose to use sheet level =IF(OR formulas. You may choose to stay completely with VBA. My point is you may be able to have your macros fire at staggered times by using the counter code. You may want to consider using the Private Sub Worksheet_Calculate event and add multiple statements such as; If [A1].Value = 1 Then..... to fire your macros when the code reaches certain values thus separating each action.
HTH
Good luck!
Noir
