I've got three pictures inside my workbook. I want to load them into the
Picture property of a UserForm at runtime and cycle through them. Can I
avoid saving the pictures then loading them with LoadPicture?

I realise that this can be done before runtime using the steps @
http://j-walk.com/ss/excel/odd/odd19.htm but I'm wondering if it can be done
programmatically.

Cheers

Dave

Answering the same question twice tonight. Yes, Stephen Bullen's
PastePicture will do it without saving it to a file. However, if it is just
three pictures, it might be easier to save it to a file and reload it.

Robin Hammond
www.enhanceddatasystems.com


"Dave" wrote in message
u...
I've got three pictures inside my workbook. I want to load them into the
Picture property of a UserForm at runtime and cycle through them. Can I
avoid saving the pictures then loading them with LoadPicture?

I realise that this can be done before runtime using the steps @
http://j-walk.com/ss/excel/odd/odd19.htm but I'm wondering if it can be
done
programmatically.

Cheers

Dave