ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Independantly running code (https://www.excelbanter.com/excel-programming/305924-independantly-running-code.html)

nath

Independantly running code
 
Hi

I dont know if this is possible, but i have a few command
buttons on an excel sheet and would like to use the mouse
over to put a comment in the status bar to tell the user
what the buttons do. The after say 10 seconds i would
like the status bar to return to saying "Ready...." is
there a way of instigating a piece of code to run and
reset after 10 seconds without halting the other code?

TIA

Nath

Frank Stone

Independantly running code
 
I personally never have a use for it in excel but i have
in access. do a search on syscmd or sysmeter. I pluged
both into my excel help and got nothing but then i may not
have the correct library activated.
good luck.
-----Original Message-----
Hi

I dont know if this is possible, but i have a few command
buttons on an excel sheet and would like to use the mouse
over to put a comment in the status bar to tell the user
what the buttons do. The after say 10 seconds i would
like the status bar to return to saying "Ready...." is
there a way of instigating a piece of code to run and
reset after 10 seconds without halting the other code?

TIA

Nath
.


Tom Ogilvy

Independantly running code
 
These are not supported in Excel.

--
Regards,
Tom Ogilvy

"Frank Stone" wrote in message
...
I personally never have a use for it in excel but i have
in access. do a search on syscmd or sysmeter. I pluged
both into my excel help and got nothing but then i may not
have the correct library activated.
good luck.
-----Original Message-----
Hi

I dont know if this is possible, but i have a few command
buttons on an excel sheet and would like to use the mouse
over to put a comment in the status bar to tell the user
what the buttons do. The after say 10 seconds i would
like the status bar to return to saying "Ready...." is
there a way of instigating a piece of code to run and
reset after 10 seconds without halting the other code?

TIA

Nath
.




Tom Ogilvy

Independantly running code
 
Look at Chip Pearson's page on the Ontime method

http://www.cpearson.com/excel/ontime.htm

What he has is more than you need, but it should give you the idea.

--
Regards,
Tom Ogilvy

"Nath" wrote in message
...
Hi

I dont know if this is possible, but i have a few command
buttons on an excel sheet and would like to use the mouse
over to put a comment in the status bar to tell the user
what the buttons do. The after say 10 seconds i would
like the status bar to return to saying "Ready...." is
there a way of instigating a piece of code to run and
reset after 10 seconds without halting the other code?

TIA

Nath





All times are GMT +1. The time now is 07:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com