O
OzziePete
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?
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?