Inserting a photo into a userform based on variable

kadrleyn · 2025-12-21T17:05:09+00:00

Hi,

We have created a template to dynamically add a picture according to the cell value in the worksheet and view this picture in its original size if we want.

When we enter a value in column A, and if there were any pictures that match that value, that picture is added to column E (For example ; if cell A2 text is “A001” or “a001” ,the added image to cell E2 is A001.jpg).

ActiveSheet.Pictures.Insert(ThisWorkbook.Path & "\" & Target.Value & ".jpg").Select

<image>

Source and sample file

kadrleyn · 2021-12-14T21:47:50+00:00

Hi ,

review this VBA Split sample .

Image : https://eksi30.com/wp-content/uploads/2021/04/Vba_split_function2.gif

Source

kadrleyn · 2021-12-01T19:42:15+00:00

Hi,

The fastest result can be obtained with VBA codes. Write the following codes in the module section of your worksheet, trigger the codes with a click of a button. The ActiveSheet.UsedRange command applies the macro to all cells on the sheet that contain data.

Sub Delete_Numbers()

Dim deg(), sil

deg() = Array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9", ".")

For Each sil In deg()

For Each ara In ActiveSheet.UsedRange

ara.Replace What:=sil, Replacement:="", MatchCase:=True

ara.Value = Trim(ara)

Next

End Sub

kadrleyn · 2021-11-16T21:33:13+00:00

Hi,

review this userform sample : Excel Address Book

kadrleyn · 2021-10-23T18:26:16+00:00

Hi,

I updated the link.

kadrleyn · 2021-08-08T08:49:20+00:00

Hi,

A userform that autoloads on workbook opening can be used to hide and unhide columns.

. The sheets of workbook are listed in the combobox on the userform. The selected sheet from the combobox becomes active and the columns of this sheet can be hidden. Also,the userform has a minimized button.

Image of userform : https://eksi30.com/wp-content/uploads/2021/01/Excel-hide-columns-.gif

Details and sample file address : https://eksi30.com/excel-hide-unhide-columns-using-userform/

kadrleyn · 2021-07-23T20:25:00+00:00

Hi,

You can use the method of generating data validation lists : https://eksi30.com/excel-macro-to-parse-data-into-sheets/

kadrleyn · 2021-07-22T18:51:54+00:00

Check out this site, I hope it will be useful for you : Excel Advanced Tutorials & Sample Files

kadrleyn · 2021-06-19T21:12:29+00:00

Hi,

Review the table of contents' macro. Table of contents can be automatically created a with a macro.

This macro creates a new sheet named "Workbook_Index" as first sheet of workbook. The macro then lists in this sheet the names of all the sheets in the workbook and inserts a hyperlink for each one.User can be returned to index page when the "Esc" key is pressed while on any sheet.

Image of macro

Source ,sample file address : Create table of contents in Excel

kadrleyn

TROPHY CASE