macro to scroll the worksheet and continue to run macro in backgro
 

I would like to display 20 rows of info, pause 20 secs, scroll 20 more until
I get to the end of the data.

I got it working, but only could stop the macro by using 'esc' key which
will throw off users when they get the stop or debug screens.

I tried to show a form with a command button, but that made the macro stop
until the form was unloaded.

I am trying to replicate the presentation mode of powerpoint, but use the
power of excel to check time functions and notify the users when a time has
passed as related to current time.

macro to scroll the worksheet and continue to run macro in backgro
 

Hi Micah,

Could you post the amount of code you have working?

"Micah" wrote:

I would like to display 20 rows of info, pause 20 secs, scroll 20 more until
I get to the end of the data.

I got it working, but only could stop the macro by using 'esc' key which
will throw off users when they get the stop or debug screens.

I tried to show a form with a command button, but that made the macro stop
until the form was unloaded.

I am trying to replicate the presentation mode of powerpoint, but use the
power of excel to check time functions and notify the users when a time has
passed as related to current time.

macro to scroll the worksheet and continue to run macro in bac
 

basically,

turn off screen display

for x = 1 to last row of data
wait about 10 seconds
use code to pick a row
turn on screen display
select row (between 1 an last row)
turn off screen display

code to look at data in rows for time comparison

next

If I form.show, how can I leave this form on the screen (turn on screen
updating first) with a command button to stop the macro (to get back to edit
mode vice display mode) yet allow the macro to continue checking rows in the
background?




"JRForm" wrote:

Hi Micah,

Could you post the amount of code you have working?

"Micah" wrote:

I would like to display 20 rows of info, pause 20 secs, scroll 20 more until
I get to the end of the data.

I got it working, but only could stop the macro by using 'esc' key which
will throw off users when they get the stop or debug screens.

I tried to show a form with a command button, but that made the macro stop
until the form was unloaded.

I am trying to replicate the presentation mode of powerpoint, but use the
power of excel to check time functions and notify the users when a time has
passed as related to current time.