D
David
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?
'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?