| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing worksheet while running macros
hi
i have a macro running and spewing database query output to Sheet1 of the workbook after getting data from a database. How can i edit the data on Sheet1 while the macro is running ?? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Editing worksheet while running macros
Explore DoEvents?
-- _______________________ Naz, London " wrote: hi i have a macro running and spewing database query output to Sheet1 of the workbook after getting data from a database. How can i edit the data on Sheet1 while the macro is running ?? thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Editing worksheet while running macros
Naz wrote: Explore DoEvents? -- _______________________ Naz, London " wrote: hi i have a macro running and spewing database query output to Sheet1 of the workbook after getting data from a database. How can i edit the data on Sheet1 while the macro is running ?? thanks hi thanks. I am actually running a UserForm and when user press a button, it will go to a backend database to query for some data and the results will be shown on Sheet1. Sometimes the data is so huge that it will span a whole sheet all the way down. This is where i hit problem because i can't scroll, can even click on the sheet, unless i stop running the UserForm. any exmaple on how to use DoEvents for this ? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Editing macros | Excel Discussion (Misc queries) | |||
| Editing Macros | Excel Discussion (Misc queries) | |||
| Macros editing and exporting | Excel Worksheet Functions | |||
| Running a script while editing a cell | Excel Discussion (Misc queries) | |||
| Editing Custom Worksheet Menu Bar in XL97 & Associtated Macros | Excel Programming | |||
Hybrid Mode
