| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
All time running macro
Basically no, not simultaneously.
"MrHappy" wrote: Edwin, This is very useful information you have forwarded to me... I am just wondering, is it possible for a macro to be running at the same time as a person is typing in data...not when they make a change to then have the macro run...but have the macro always running and let the user imput or whatever they want to do? Does that help any? "Edwin Tam" wrote: If you want a macro to run every time the user enters anything or changes anything on a particular spreadsheet, you can use the Change event of that worksheet. In VBA Editor, in projects, under your workbook, under Microsoft Excel Objects, double-click that worksheet and enter the macro below. Private Sub Worksheet_Change(ByVal Target As Excel.Range) MsgBox "worksheet changed" End Sub If you want a macro to run every time the user enters anything or changes anything on ANY worksheet, you can use the SheetChange event of the workbook. In VBA Editor, in projects, under your workbook, under Microsoft Excel Objects, double-click "ThisWorkbook" and enter the macro below. Private Sub Workbook_SheetChange(ByVal Sh As Object, _ ByVal Target As Excel.Range) MsgBox "one of the worksheets changed" End Sub Regards, Edwin Tam http://www.vonixx.com On 1/12/05 5:05 AM, in article , "MrHappy" wrote: Is there a way the user can input data into a spreadsheet and have a macro running at the same time? Like moving water or flying birds while they enter the data? tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running a macro based on the time | Excel Discussion (Misc queries) | |||
| Running a macro at a specified time | Excel Discussion (Misc queries) | |||
| Running a macro at a certain time | Excel Discussion (Misc queries) | |||
| running macro at automatic time intervals | Excel Worksheet Functions | |||
| Running a macro at a certain time | Excel Programming | |||
![gocush[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
