picture change

[gekko66uk]

I have a user form which i wish to insert an image based on the name stated in textbox1. bont know how, i think it should be something like the below but it is just a guess.

Private Sub CommandButton1_Click()
Dim picname As Variant
If TextBox1.Text = "" Then
Else
Image1.Picture =("C:\images\ "&picname&"&.jpg)

End Sub

 

[Armando Montes]

Check this thread:
http://www.mrexcel.com/forum/<WBR>showthread.php?t=556626

 Private Sub ComboBox1_Change() 
    UserForm1.Image1.Picture = LoadPicture("c:\folder\" & ComboBox1.Value & ".jpg")
End Sub