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

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

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