Add pictures to UserForm at runtime
 

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

Add pictures to UserForm at runtime
 

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