: 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 = LoadPicture(VBAProject.ThisWorkbook.Path & "\pics\" & Sheet1.ComboBox1.Value & ".jpg")
This should be enough..
(note: Do not use + for concating strings... it may cause unexpected things when u use magic data type conversions.. (all classic vb converstions))
Don't take life too seriously anyway you won't escape alive from it!