View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default Embed Pictures in Workbook

Was wondering if there was a way to do this????

This is what I have to display a selected picture in a UserForm:

Image1.Picture = LoadPicture("I:\2004 Yankees Schedule\Logos\" & _
Label1.Caption & ".jpg")

With the above, I can display the .jpg that's associated with the
caption in Label1. If Label1.Caption = "Oakland", it'll display
the oakland.jpg as the Image picture.

What I'd like to be able to do is have those .jpg's included in the
workbook and still be able to achieve the same functionality.
Not worried about the size of the workbook as all 30 jpg's
only add up to about 180 kB.

Any ideas??

Thanks,
John