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.

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.

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.