Userforms & Images

[privxls]

Hi MrExcel,

I have this mini-project where I plan to make a website simulator (offline) by means of screenshots/pictures.

I achieve below by making transparent labels and added codes like on the labels:

Me.Hide
UserForm(number).Show

(the project is made up of over 20-30 UserForms at the moment -- the picture above is just an example)

____________________

I would just like to ask if any of you have an idea to make this more efficient rather than creating one userform per image? Any suggestions?

 

[Worf]

Hi,

you can programmatically change the image displayed on a user form control using the Load Picture function, see page below.
That way, a single user form will display different images, controlled by VBA.

http://www.globaliconnect.com/excel...th-getopenfilename-method&catid=79&Itemid=475

 

[privxls]

I just got back from a busy schedule. Thank you so much Worf for the reply, I will surely look into this.

Kind regards,
Priv