Add pictures to UserForm at runtime

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
Back
Top