Excel: Create a VBA button to open an image in worksheet


Hi! [I](Sub-Create a button to open an image in worksheet)[/I] I've been asked to have an image (small jpg file) appear and disappear in an Excel worksheet that is being used as a form. In other words, they want the user to click on a Command Button which will display an image, then give him/her the option to click the button again and the image disappears (They didn't specifically ask for a button, but I guess a button is the best option based on what I read on other threads in this forum, however if there is an alternative, that would work for me too!). I have no experience with VBA, and I wasn't able to find a similar example to my situation in this forum, where I could copy and paste the code in VB.

A B C D
1 Command Button 1 (Click here Mobile Phone pic) The Mobile Phone pic should display here
2 Command Button 2 (Click here Head Phone pic) The Head Phone pic should display here
3 Command Button 3 (Click here Land Phone pic) The Land Phone pic should display here
4
The Mobile phone pic is already in this same worksheet (Cell B90) The Head phone pic is already in this same worksheet (Cell B113) The Land phone pic is already in this same worksheet (Cell B135) Please revert back if I am not clear


This question generated 30 answers. To proceed to the answers, click here.

This thread is current as of July 18, 2014.


For more resources for Microsoft Excel