I've got three image controls in a worksheet (Sheet 1), which changes pictures based on the item selected in a cell (Range "Loan_number"). The image controls work fine when changing the value of the cell containing the name range "Loan_number".
However, seems there is some glitch with vba refreshing the image every time I use the printout. I'm not sure what causes the image not to update when selecting new items (and hence new pictures) from the list. The image updates for the first iteration, but then it stops updating until all the jobs are sent to the printer (and unfortunately all the jobs contains the same picture, which defeats the purpose of the macro). Once the printing is sent, it refreshes the image control with the last chosen "Loan_Number" in the list.
If I debug and step through this code, it actually refreshes the image controls and the pictures without any problem.
Note that I've played with various ways to refresh, calc, full recalc etc. in order to "jump start" and force a refresh in between print jobs.
Help would greatly be appreciated it.
Bookmarks