picture name as variable

[trenars]

Hi, there!

I have userform (AddData) that has combobox (LineNumber) with values "Line 1", "Line 2", "Line 3", "Line 4". I've got a folder with corresponding pictures Line1.bmp, Line2.bmp, Line3.bmp, Line4.bmp
What i'm struggling with is to get AddData.Image1.picture display line picture. Could someone help me please.

Current code i came up with is:
Private Sub LineNumber_Change()
Dim picture As Object
filelocation = Sheets("Admin Data").Cells(3, 4).Value
picture = "Line" & Right(AddData.LineNumber, 1) & ".bmp"
AddData.Image1.picture = LoadPicture(filelocation & picture, 30, 90)
end sub

[Domski]

Duplicate post: http://www.excelforum.com/excel-prog...-variable.html

Dom