I have about a dozen pictures that I have manually put into sheet 2. In sheet 1 I have a button that launches a user form that has nothing in it. I just want it to pop up and I want to dynamically change the background image (UserForm.Picture property) to one of the pictures from sheet 2. However, I don't have the file paths. I want this to all be self-contained. I have manually changed the names of the images so they're easy to remember and identify. I have tried doing something like this with no luck:
MyUserForm.Picture = MyPictureControlName 'one of the 12 pictures
MyUserForm.Show
But this throws an error.
LoadPicture is great, but requires a file path, which I don't have.
Ideas?
Thank you!
Bookmarks