Excel Image Array?

[danomaniac]

Hi - I have an excel sheet with 5 image controls -

I'm loading pictures using the loadpicture method which works fine - however I have to send the pictures with the workbook - I'd like to have all the pictures on a seperate sheet in image controls, i.e. sheet2.image1, sheet2.image2, etc - then when I need a picture on sheet 1 ;

now it's like this and works but is clumsy:
select case y
case 1: sheet1.image1.picture = sheet2.image1.picture
case 2: sheet1.image1.picture = sheet2.image2.picture
etc....
end select

I want to do it like this but can't figure it out...

sheet1.image1.picture = sheet2.image(x).picture


"It's more like it is now, than it ever has been."

 

[SkipVought]

Hi,

How to use the Watch Window as a Power Programming Tool faq707-4594

Skip,

_[red][/red]