How do I copy cell values in VBA
 

I have 2 sheets in the same workbook. Each cell in Sheet2 contains a picture
that was imported from a .png file.

In Sheet1, I'd like to have a button that, when clicked, selects 5 random
pictures from the cells in Sheet2 and copies them to 5 pre-selected cells in
Sheet1. The VBA code that generates the random numbers and maps them to the
appropriate cells in Sheet2 is working fine, but I can't get the actual
copying from one sheet to the other to work. Is this doable, and can I do it
without having the sheets flash back and forth in the screen? Ideally, I'd
like to see each selected cell in Sheet1 just get filled with a picture.

I am a novice at VBA, and I thought I could do this in Excel, but maybe I
have to get VB and write a standalone application?

Thanks for any insight into this.

Jurado