View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default 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?