Updating an ActiveX Image Control While Running a Macro

[macohen]

Currently I use a macro to export a page as a pdf. This page is generated whenever I change the document number in a certain cell. At the bottom of this page are 3 activex image controls that load pictures depending on which document is selected. Everything works fine, and my pages export nicely, except that the 3 activex image control frames I have do not update their pictures while the macro is running. If I change the document number manually the frames update. If the macro does it, the frames don't until the macro finishes.

The VBA code that allows for the images to update is a part of the worksheet's code, while the PDF macro is a module. Could this be the problem?

Thanks

 

[Gary McMaster]

Just a guess ...

Try adding "DoEvents" to your code. That will force the operating system to do some housekeeping.

Gary

 

[macohen]

I actually just figured this out around 30 minutes ago. Thank you for the response though.