image array, referencing images

Err, my apologies if I gave the impression I wanted you to do my shopping, I just want to know where the shops are.

I think I've tracked sown the answer.

Something called SHAPE gives the user more options to manipulate images, hopefully I can report back when I've read up some more on how to use it.

Thanks for your help Andy.

I have looked at the coding used in several card games and the answer now seems obvious.

It can't be done using Excel, well not in the way I was looking to do it.

The games use the system assigned names "Image1", "Image2", etc and use repeating code to manage each Image directly, rather than assign the images to an array and use generic routines to manipulate the images. i.e. playing_card_image(x) = such and such.

Although this hasn't given me the answer I was looking for, it has saved me more weeks of searching for an answer that doesn't exist.

Many thanks to all who have took the time to read my question and especially Andy Pope for pointing me in the right direction.

I will leave this post open for a few days, just in case anyone has a cunning work around.

While pulling what little of my hair out and randomly hitting my head on the keyboard in the help section of Excel I found I could do this.

Dim card( 0 to 52) as Image
set card(0) = Image53 ; Card Back
set card(1) = image1 ; Ace of Clubs
.
.
set card(52) = image52 ;King of Spades

Which now means I can assign the shuffled cards images to specific images in my userform.

and as for animating the cards, a simple loop, incrementing the LEFT and TOP values will suffice.

Well that's enough to get me on my way, thanks all.

cheers

col

Cheers snb

Not quite my problem, but it has given me ideas.

basically my problem is I can't see a way of referring to image objects other than by explicitly calling them by name as in "Image1", "Image2", etc.

For example

If the user clicks on the ace of clubs, which is image1 (out of 36 on the sheet) the click event checks to see if this is a valid choice, moves the image in discreet steps to a play area, sets the zorder based on value against other played cards and updates various AI components.

This code, with my current understanding, will need to be replicated for each image (that's 36 times)
As passing an image object as a variable to a subroutine doesn't appear possible.

but still, I like your code and will keep this in mind for future projects.

many thanks

col

Thanks for the interest snb.

I've run off a quick example as you suggested.

It's probably wise to assume I am a complete novice and that the obvious route isn't that obvious to me as I come from a spaghetti basic background, not object orientated and certainly not structured.

What-ever you suggest will be welcome, even if it's a curt "Read book xyz"

i know this is an old topic, but the answers are not satisfying, so:

to put a picture from a workbook's sheet to a form, i first save it to the disk, and then to the form (i use a ssd, on standard hard drive might be slow).

this code in a module (code not modified, can be shorter)

Please Login or Register  to view this content.

and then in the userform : (code can be made shorter, ajust names of control forms)

Please Login or Register  to view this content.