ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   JW Progress Bar after DoubleClick event (https://www.excelbanter.com/excel-programming/441235-jw-progress-bar-after-doubleclick-event.html)

David

JW Progress Bar after DoubleClick event
 
I've been successfully using the progress bar from John Walkenbachs
'Spreadsheet Page' on apps where the code takes a while to crunch..
Would like to use same for the an app where the code is fired by a
DoubleClick event in the sequence below

BeforeDoubleClick(Arg1, Arg2, etc.)
UserformShow
UserformActivate
Call Main(Arg1, Arg2)
Run process and update progress bar
end process and unload form

Trouble is I need to pass arg1 & arg2 from the DoubleClick event for Sub
Main to process
How can this be achieved?


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com