Hi
Have you tried throwing in a LOT of DoEvents e.g. every time a
scrollbar updates.
regards
Paul
On Apr 17, 8:16*am, Brotherwarren <twar...@kesgrave.suffolk.sch.uk>
wrote:
> Hi folks,
>
> Does anyone know anything at all about this problem:
>
> I have a worksheet containing a scroll bar, taken from the control
> toolbox.
> The code for this scrollbar'schange event copies information from
> about 20 different cells into about 20 textboxes, displayed on the
> worksheet. *Again, they are control toolbox textboxes.
>
> I have a separate sub, PrintSelectedValues that sets the value of the
> scrollbar, then prints out the results, then changes the scrollbar
> value again before printing a new page, then changes...for about 50
> different scrollbar values
>
> the problem is that the PrintSelectedValues sub to change the
> scrollbar's values seems to outpace excels ability to refresh the
> textboxes, and I get a jumbled mess of results. *The first page to
> print is fine, then PrintSelectedValues changes the scrollbar's value
> but the textboxes don't update in time. *The paper copy contains some
> information from the first scrollbar value, mixed in with some from
> the second.
>
> I've tried to use a *DoEvents command before the print command but I
> still get the same problem
> Many thanks for any and all advice!
>
> \Tony
|
