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:

Sub update_data()
Sheet1.Cells(2, 2) = Sheet1.ComboBox1.Value
Sheet1.Image1.Picture = VBAProject.ThisWorkbook.Path + "\pics\"+ Sheet1.Cells(2, 2) + ".jpg"
End Sub

: 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:
:

 Sub update_data()
    Sheet1.Cells(2, 2) = Sheet1.ComboBox1.Value
    Sheet1.Image1.Picture = LoadPicture(VBAProject.ThisWorkbook.Path & "\pics\" & Sheet1.ComboBox1.Value & ".jpg")
 End Sub

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))



Pavlin II[/size]

Don't take life too seriously anyway you won't escape alive from it!

This message was edited by cjd at 2004-10-5 7:49:38

---

Thanx,
That worked