Most valuable professional
  • Hot Topics

Excel Create a VBA button to open an image in worksheet

Hi! (Sub-Create a button to open an image in worksheet) 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. 1 2 3 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel