thunderfoot
Board Regular
- Joined
- May 28, 2004
- Messages
- 229
I have a worksheet in a file (linked to another EXCEL file which is constantly updated with 'live' information) that will operate a Module Macro routine when a button is pressed.
But before the button is pressed I want to be able to set-up an Audible 'BEEP' when one cell exceeds the value in another cell. This is currently done with a Visual Trigger (i.e. Conditional Formatting).
Is there a way to set-up a macro or something that runs constantly to identify (Audibly) when the value in one cell exceeds the value in another cell? Whilst this is running I still need to be able to invoke my Module Macro using a button.
Not sure how Worksheet/Workbook modules operate and how they are invoked, but is this the way to do it? If so, how?
But before the button is pressed I want to be able to set-up an Audible 'BEEP' when one cell exceeds the value in another cell. This is currently done with a Visual Trigger (i.e. Conditional Formatting).
Is there a way to set-up a macro or something that runs constantly to identify (Audibly) when the value in one cell exceeds the value in another cell? Whilst this is running I still need to be able to invoke my Module Macro using a button.
Not sure how Worksheet/Workbook modules operate and how they are invoked, but is this the way to do it? If so, how?