Thanks for the advice.
I agree with the error checking. It is an important step. Tricky part
about an add-in, one error and Excel can vanish; and we will tell ms.
Screen updating. Well I did bench mark this. Certainly it is faster when
we are not updating but it is even more fast when we wiggle the title bar.
It is odd.
By the way, I will keep the screen updating visible for this app. Eye Candy
"broro183" wrote:
hi Richard,
In Excel's VBA, I would suggest using
Code:
--------------------
application.screenupdating = false
--------------------
but I'm not sure if you are using VBA or VB which may use a different
syntax.
I suspect that the action of selecting the title bar implicitly forces
Excel to undergo something similar (if not the same) to the above code.
Also I would have to do less error checking. If the user were busy
speeding up the application by wiggling the window around, I would not
have to check for user interference on the sheet?
While I've read your comment that the thread is not about how to write
information to a sheet, I think it would be worth your while writing
"the text" to an array & then adding this to the sheet in a single hit
(depending on the full size). This is likely to be much quicker than
looping through one cell at a time (esp using the above line of code).
Also, the increased speed further minimises the time for the user's
attention to change focus & I think this is of more value than promoting
the active involvement ("wiggling the window").
If you are planning on distributing this add-in then I highly
recommending adding all the error checking - if you can think of a
potential error it is likely to be raised by users. Plus, it's likely
that there will be some errors that you don't think of which may be
highlighted as you test the error handling that you do add.
hth
Rob
--
broro183
Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97135