How to use and Add the Image ActiveX Control and Show an Image to an Excel Workbook

Excel is one of the most powerful tools present in Microsoft, it is undoubtedly one of the essential programs for any type of work. If you want to learn how to use and Add the Image ActiveX Control and Show an Image in an Excel Workbook , you should read the following article.

With this advanced function it is possible to use the ActiveX spinner in an Excel sheet in order to simplify the work in your tables. Similarly, it is possible to use it for images.

How to Use and Add the Image ActiveX Control and Show an Image to an Excel Workbook

Using the Image ActiveX control can be especially useful for tables and complex textbooks, using this function it is possible to add and edit parameters related to images and photographs.

How to use and add the Image ActiveX control and display an image in an Excel workbook

ActiveX options are very useful to improve our Excel tables , they are usually a tool for advanced users, but undeniably their use has great benefits. With them it is possible to automate our Excel workbooks , even to add buttons for different functions.

In addition to the aforementioned, it is recommended that you learn about how to configure the ActiveX text control and command button in Excel , something that could help you understand the process below.

See also  How to Remove and Use the Ruler Tool in Photoshop Step by Step

If you are interested in adding a button with which you can easily add an image to an Excel workbook, read the following guide:

  1. The first thing to do is go to the Developer section, within this menu you must locate the Insert function, press on it and then go to the ActiveX controls tab.
  2. There the image option (ActiveX control) will appear , click on this option.
  3. Once you have clicked on the previous option, a small box will appear on the screen, this is the box of your image, adapt it according to the size in which you want it to appear.
  4. Now you will need to insert a command button to generate the button to add an image to your Excel workbook. To do this, go to the developer section, click on insert and finally click on the Command Button option on ActiveX controls.
  5. Put the button in the place that seems best to you, for this drag it and leave it in the size that you consider most appropriate.
  6. The button configuration options will be displayed on the screen. The first thing to modify is the name, press on (Name) and write the name that seems best to you, such as ” SelectImage “.
  7. Now go to the Caption section and put the name that will be displayed on the button, such as “Select Image”.

Add an ActiveX control button to add an image

The process of creating the code within Microsoft Excel can seem complicated to most users and this is where they usually don’t know what to do. In any case, following our guide, you can make a button to create an image very easily:

  1. Click on the image box and then on the option See code.
  2. The screen for the code will appear, change the option from (General) to Select Image . Make sure the option next to SelectImage is on Click.
  3. It is time to create the variable, in the code window, as the first line type .dim image as Variant and press Enter.
  4. In the next line of code you must write the following image = application.GetOpenFilename (File-Filter: = “Image * .gif; * .jpg; * .jpeg; * .png; * .bmp, * .gif; * .jpg ; * .jpeg; * .png; * .bmp “, Title: =” Select Image “, MultiSelect = False).
  5. In the next line of code you will need to write the following Image1.Picture = LoadPicture (image) .
  6. Now you just have to click on the Save option and close the code window.
See also  How to Use a Credit Card POS Machine to Cash Out - Quick and Easy

By performing the above procedure you will have a functional button with which you can easily add an image to your Excel workbook.

You can also configure the ActiveX option button and customize text in the linked cells , another excellent automation function when using the tool in this office software.

Leave a Comment