I have designed a user form with Team Graphics for a results ladder
named after the Teams eg, "Hawks", "Cats" etc.... (16 in all)
I need to be able to assign these picture properties to other image controls
on both Worksheets and other UserForms by using a variable
lets say there is are 16 images on Worksheet "Ladder" Called Team1, Team2
etc how do I loop through through these images of this worksheet and assign
the right picture based on a variable Team Name. Don't laugh but I am
currently getting around this with 16 sets of subs using 16 Select Case lines?

Nam e the pictures the same as the team name. You can select the picture
using hte following:

Set MyPicture = Sheets("Sheet2").Pictures("Hawks")

I would need to see more of your code to give you a better answer.




"OzziePete" wrote:

I have designed a user form with Team Graphics for a results ladder
named after the Teams eg, "Hawks", "Cats" etc.... (16 in all)
I need to be able to assign these picture properties to other image controls
on both Worksheets and other UserForms by using a variable
lets say there is are 16 images on Worksheet "Ladder" Called Team1, Team2
etc how do I loop through through these images of this worksheet and assign
the right picture based on a variable Team Name. Don't laugh but I am
currently getting around this with 16 sets of subs using 16 Select Case lines?