Re: Excel 2003 - VBA - Forms

Giganews Newsgroups
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
...place data
Application.Calculation= xlCalculationAutomatic

Also, if you have any event code running, like Worksheet_Change, you might
want to turn that off too.

--
Jim
"Craig Brandt" <brandtcra…@att.net> wrote in message
news:SMMck.14996$N87.8…@nlpi068.nbdc.sbc.com...
|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
therefore
| 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
at
| 17 secs, was a bit excessive.
| My exit routine had a lot of the following types statements to transfer
the
| data:  Sheets("AllAcct").Cells(2,3) = Userforms2.StartDate
|
| Is there a better way of handling the data transfer?
|
| Thanks,
| Craig

Replies

In response to

Excel 2003 - VBA - Forms posted by Craig Brandt on Tue, 8 Jul 2008