Use Loop to set Picture Property of image on User Form

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?
 
J

joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top