Importing images into userform

[MrPink1986]

Hi,

I have a multi page user form that I am using to predict scores for the premier league soccer fixtures each week. Within each page I have 1 fixture made up of a home team and an away team. This data changes week on week depending on the a web import. I want to add two images to each page which will represent the team crest of the team in each text box.

I have the team crests on a tab named "Pictures" with each crest in a cell beginning with C2.
My text boxes are named Fixture1_Home Fixture1_Away - Fixture10_Home Fixture10_Away this will pick up the 20 teams each week.

In my image box I want some code to say if Fixture1_Home is X then pick up the picture and apply this to the image box (my image boxes are named Fix1_Home_Image, Fix1_Away_Image etc)

Once this is defined I am then presuming I can call the Sub UserForm_Initialize stage.

I have attempted the below for the Manchester United team as the away team in the fixture 9 test box.

Private Sub Fix9_Away_Image_Click()If Fixture9_Away_Change = "Manchester United" Then
Fix9_Away_Image.Picture = Sheets("Pictures").Range("C2")
End If
End Sub

Any help is greatly appreciated.

 

[MrPink1986]

Re: Help importing images into userform

Apologies - I wish to have the team names and team pictures on a tab named -"Info" - I will have this tab hidden and only used as a reference.
The userform will be opened on a different tab.

I do not understand what you want
- are you asking if it is possible to have ALL the logos & team names on the same tab?
- are you referring to the userform or the worksheet

 

[Yongle]

Re: Help importing images into userform

Yes
- amend the code to reflect the new sheet name
- the code should work with a hidden sheet
- open the userform on any tab

 

[MrPink1986]

Re: Help importing images into userform

Ok cool thanks it seems I only need to change "Set Ws = Sheets("Logos")" to the name I have in my WB. Do I need the two subs to run this?

Yes
- amend the code to reflect the new sheet name
- the code should work with a hidden sheet
- open the userform on any tab

 

[Yongle]

Re: Help importing images into userform

Yes you require both subs ( but see Zipping below)

How it works
You said you wanted to distribute the workbook with the images embedded BUT my code uses the images from a folder on a local drive not from the workbook
So the images need to be placed in a folder on every computer - that is what CreateJpegs does
The recipient should only need to run this once to place the imges in the folder - they stay there unless deleted

Zipping?
Have you considered zipping the files?
- if the image files are not embedded, but 22 separate files, then the workbook and image files could be zipped together and the recipient could unzip into a single folder
- CreateJpegs would then not be required

 

[MrPink1986]

Re: Help importing images into userform

OK thanks I like the idea of each user creating the files on the drive. Do I need to define a path? How do I know where the JPEGs go?

Yes you require both subs ( but see Zipping below)

How it works
You said you wanted to distribute the workbook with the images embedded BUT my code uses the images from a folder on a local drive not from the workbook
So the images need to be placed in a folder on every computer - that is what CreateJpegs does
The recipient should only need to run this once to place the imges in the folder - they stay there unless deleted

Zipping?
Have you considered zipping the files?
- if the image files are not embedded, but 22 separate files, then the workbook and image files could be zipped together and the recipient could unzip into a single folder
- CreateJpegs would then not be required

 

[Yongle]

Re: Help importing images into userform

The macro places the files automatically in the same folder as the workbook
Unzipping would also do the same

 

[MrPink1986]

Re: Help importing images into userform

The macro places the files automatically in the same folder as the workbook
Unzipping would also do the same

Thanks for your help with this one - I now have my spreadsheet working with the pictures been generated from the sheets.

 

[Yongle]

Re: Help importing images into userform

thanks for the feedback