Emoncada
12-05-2013, 10:45 AM
I have a spreadsheet with 2 rows of data range("B3:Q4").
I have a Userform with an Image Control assigned to each cell in that range (No Image assigned).
Example ImgB3, ImgB4, ImgC3, ImgC4... etc.
The Userform has Images named "ImgDebbie", "ImgPeter", "ImgDennis".
These Images are not visible once userform starts.
What I need is for when userForm_Initialize starts.
I need something to look at the spreadsheet cell B3 and then if it says "Debbie"
I need Me.ImgB3.Picture = ImgDebbie.picture
And then have it look at cell B4 and do the same.
I believe I can possibly do this a very long way having each ImgB3-ImgQ4 test for the possible name and return image, but i would have a lot of code, since I would need to do it for each img.
I hope i was able to be clear on my situation.
Any help would be great.
I have a Userform with an Image Control assigned to each cell in that range (No Image assigned).
Example ImgB3, ImgB4, ImgC3, ImgC4... etc.
The Userform has Images named "ImgDebbie", "ImgPeter", "ImgDennis".
These Images are not visible once userform starts.
What I need is for when userForm_Initialize starts.
I need something to look at the spreadsheet cell B3 and then if it says "Debbie"
I need Me.ImgB3.Picture = ImgDebbie.picture
And then have it look at cell B4 and do the same.
I believe I can possibly do this a very long way having each ImgB3-ImgQ4 test for the possible name and return image, but i would have a lot of code, since I would need to do it for each img.
I hope i was able to be clear on my situation.
Any help would be great.