I am creating a program in excel. The user needs to pick a picture from a normal combo-box which will then appear as an image on the worksheet.
the code I use for the macro is:
Sheet1.Cells(2, 2) = Sheet1.ComboBox1.Value
Sheet1.Image1.Picture = VBAProject.ThisWorkbook.Path + "pics"+ Sheet1.Cells(2, 2) + ".jpg"