S
steph
hi group,
I've got an excel-sheet containing some vba-code. There's one sub that
does some calculations in a loop which can run for some time. My users
now want to be able to escape from this calculation by pressing
<escape> or clicking a button on the sheet. But actually excel is
frozen while calculating.
What is the most common way to achieve this? I guess it must be
possible to solve this with excel-events, but I'm not very experienced
in using them.
thanks for any hints,
stephan
I've got an excel-sheet containing some vba-code. There's one sub that
does some calculations in a loop which can run for some time. My users
now want to be able to escape from this calculation by pressing
<escape> or clicking a button on the sheet. But actually excel is
frozen while calculating.
What is the most common way to achieve this? I guess it must be
possible to solve this with excel-events, but I'm not very experienced
in using them.
thanks for any hints,
stephan