Raffle Draw: Dynamically changing the picture based on the formula

I want to randomly select a food on a list that changes when I press the go button and the picture that corresponds to the food will display

I was able to accomplish that but however, I encounter a slight issue. When I press go for the next random food, it will display the last picture in half.

How I can get rid or fix this behavior.

please check my file.. Thank you.

https://drive.google.com/file/d/0B0W...ew?usp=sharing


Can't delete my post to the other forum:

Here is the link:

https://www.mrexcel.com/forum/excel-...d-formula.html

Hi etukram

It has to do with the interval of image views and dependent on speed of processor I think.
On my pc it works fine if this code is brought back...Play around with your balance of sleep and Wait time

Please Login or Register  to view this content.

Have a look at this link....Excellent with clean code....Perfect for your requirement
http://www.mcgimpsey.com/excel/lookuppics.html

Sure it is possible. Will look into it in the morning..