Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anyone know an answerr?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anyone know an answerr?
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|