|Subject:||Re: Excel 2003 - VBA - Forms|
|Posted by:||Jim Rech (jrre…@hotmail.com)|
|Date:||Tue, 8 Jul 2008|
Sounds like calc mode is automatic. If so, change to manual at least while
your code is putting data in the worksheet:
Application.Calculation = xlCalculationManual
Also, if you have any event code running, like Worksheet_Change, you might
want to turn that off too.
"Craig Brandt" <brandtcra…@att.net> wrote in message
|I am starting to use "userforms" to collect data. It can help ensure that
| the data is valid and enforce placement.
| When I inserted code "on field change" that transfered that data to the
| spread sheet, there was a pause, unacceptable during data entry. I
| deferred changing the cells in the spreadsheet until all input was done in
| the forms. This time the pause occured upon closure of the userforms, but
| 17 secs, was a bit excessive.
| My exit routine had a lot of the following types statements to transfer
| data: Sheets("AllAcct").Cells(2,3) = Userforms2.StartDate
| Is there a better way of handling the data transfer?
Excel 2003 - VBA - Forms posted by Craig Brandt on Tue, 8 Jul 2008