CommandButton to Exit a Macro?

[badger.matthew]

Hi All,

I'm in the process of making the monumentus shift from Excel 97(!) to
2007 and have just discovered the joys of modeless userforms.

I am forever writing macros to edit over 2500 .csv files and have used
the status bar before now to show progress. Now, however, I have
created a modeless userform that gives a visual indication of progress,
using the code below. Is it possible to add a 'Cancel' button somewhere

Thanks in advance, Matt

 

[Bob Phillips]

The flickering is a bit annoying, no?

A better example can be found at
http://www.enhanceddatasystems.com/ED/Pages/ExcelProgressBar.htm

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[badger.matthew]

Cheers Bob, works perfectly. Doesn't flicker at all on mine either.