I'd like excel by VBA to count to 20 at different speeds (that is how long is the pause before next number coming).
I have tried different methods but I find them all quite unstable, suddenly they stop updating the counter and "excel does not answer".
I'm back to basic, letting a simple loop run for several times to create a pause using this sub
Sub looptimeintervall()
timefactor = InputBox("pause value")
For i = 1 To 20
Range("h18").Value = i
For j = 1 To timefactor * 4600000
Next j
Next i
End Sub
Can anyone understanding more than me about whats happening inside excel tell me why this sub is not functioning well/stop updating, when timefactor is about 10 and greater.
I have tried several other ways (wait, timer and so on) but they are not stable either. Have any of you an idea of a stable counter sub?
Yes I will tell you later what this is for!
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar