forcing a textbox to update
 

Hi folks,

Apologies if a solution is posted elsewhe

I have a for .....next loop that contains a line to print a worksheet.

The worksheet that is printed contains around 30 textboxes, all taken
from the control toolbox.

The first 20 pages print without problem, but gradually the textboxes
fail to update in time for the next print.

I found a suggestion elsewhere to include a doevents command, but this
didn't work.

Another suggestion said to use a .refresh command, however I get an
object doesn't support this method error.

Here's the line: Worksheets("pupil flightpath").TextBox28.Refresh


Is there a problem with my syntax or is there another way to solve
this problem.

Many thanks for any and all advice!

\Tony