✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
Continuing with the topic of database in Excel, now I share an example where we use the control Image of vba to be able to show images in a form.
How does it work
We have an Excel table where we will insert data of Super Heroes, such as his Name, which Editorial come from, Comments, besides inserting the route of our PC where the corresponding Image is hosted.
Record registration
The interesting thing about this form is that we will have the option to choose an image for each record that we will register. The list of images will be displayed in a ListBox where we will have a preview of each image when choosing each one of the list.
Search for records
When we have our table with records, we will now see the detail of each record with the Search for Super Heroes form.
This form has a ComboBox that is filled with the data in the Name column of the table and each time we choose an element of the Combo, the corresponding data is filled and the image is displayed. The Combo calls the VLOOKUP function (VLOOKUP).
In order for the image to be shown, it is essential that the route that is in the PICTURE column of the table is correct.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
11 окт 2024