LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Textbox on excel sheet do not update with VBA

I have a problem at present in that when I run some
simple code to update 14 textboxs on a worksheet, with
variables extracted from another worksheet (Datasheet).
Once the variables have been entered into the relevant
textboxes. The sheet is then printed.

The variable are extracted line by line on another
worksheet, entered into the textboxes on another sheet
and then printed. The next set of variables are then
extracted from the next line down (Data sheet) and then
entered into the relevant textboxes, printed, and so on
and so on.

However, the textboxes never update after the first line
of data has been completed. Therefore I end up with 30
print outs containing exactly the same data.

Any help would be appreciatted.

egards
Ben Joiner
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automaticaly update a textbox from filtered cells Panos Excel Discussion (Misc queries) 0 October 2nd 07 12:12 PM
Textbox changes position on a copied excel-sheet Hanspeter W. Excel Discussion (Misc queries) 0 July 1st 06 09:41 PM
new line at sheet textbox Tom Ogilvy Excel Programming 0 August 25th 03 12:46 AM
Accessing a textbox on a sheet.... Cyril[_2_] Excel Programming 1 August 11th 03 06:37 PM
Textbox object does not update jay Excel Programming 0 August 1st 03 03:56 AM


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"