Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forcing cell value update/refresh | Excel Programming | |||
Forcing users to update spreadsheets | Excel Discussion (Misc queries) | |||
Forcing Excel to update, or recalculate. | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Forcing Integers into Textbox | Excel Programming |