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
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...
Last edited by websailor; 06-22-2007 at 11:54 PM.
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
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!