Making Excel update a text box

[Brotherwarren]

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

 

[egarciao]

just set some properties to page setup, as:

With Worksheets("AWRS").PageSetup
.Orientation = xlPortrait
End With

this works fine