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