Solved: Auto Export cells to pop message and text file

Hi

I have 22 students
I create 12 cells to show the names of these students who have high degree
how I can auto export the 12 cells to text file and but them in pop message every 30 minutes?



any help...

Hi ws,

This may help get you started. The code is from: http://www.ozgrid.com/Excel/run-macro-on-time.htm

You'll find other examples if you google "VBA ontime"

The code is in the Workbook_Open event and a standard module as explained in the link above. In my example it is set to 30 seconds.

Cheers,

dr



Cheers,

dr

thank you so much

please see attachments

what i can change in the module?

Hi ws,

Did you forget the atachment?

Cheers,
dr

please see attachments

Hi WebSailor,

This has the timer function in it. It displays the list from Sheet1.

There is a worksheet_change macro on sheet2 that fires whenever B1: B22 change. It displays the first 12 rows that match B24. Don't know if it's useful to you or not...

Cheers,

dr

Thank U so much rbrhodes

Welcome to the Board :hi:

Don't forget to mark your thread as "Solved" once you have a solution - go to "Thread Tools" at the top of the page.

Done!