Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Image control in Excel, updating through code

cjdcjd Member Posts: 43
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

Comments

  • PavlinIIPavlinII Member Posts: 404
    : 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:
    :
    [code] Sub update_data()
    Sheet1.Cells(2, 2) = Sheet1.ComboBox1.Value
    Sheet1.Image1.Picture = [blue]LoadPicture([/blue]VBAProject.ThisWorkbook.Path & "pics" & Sheet1.ComboBox1.Value & ".jpg"[blue])[/blue]
    End Sub[/code]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))



    [blue][b][italic][size=4]P[/size]avlin [size=4]II[/italic][/size][/b][/blue]

    [purple]Don't take life too seriously anyway you won't escape alive from it![/purple]


  • cjdcjd Member Posts: 43
    [b][red]This message was edited by cjd at 2004-10-5 7:49:38[/red][/b][hr]
    Thanx,
    That worked


Sign In or Register to comment.