Update Image before Print Report in Excel VB

[AmirSoft]

Hi.
I have a workbook that contain the pictures Staff.
When I enter Staff ID then Picture automatically updated.

But now I have made a user form for print.

In user form I have a Text Box where I put Staff ID

And a Command Button, It print the Staff Detail with Picture

Sheet1.PrintOut

Now Problem is this

When I Enter a New Staff ID Excel import all the data of related staff member.
But do not update the picture.

Data of New Staff Member but Picture of old Staff Member.

How can I update the image first and then print the report.

Application.ScreenUpdate = True

This also not working.


Please give me a code.

Workbook in which I am working is very heavy and I am unable to upload.

[AmirSoft]

Is any body has the solution?