Auto Userform Picture Change

[Shake]

I have created a userform for entering my address details.

What i would like is the picture on the userform to be different each
time i open up the programme. I can not find the Excel VBA macro code
to do this.

Is it also possible to make it so that it can open on any machine?

 

[Leith Ross]

Hello Shake,

The following code will load a picture of your choice as the background
for the user form. I have never seen any documentation on this function.
So, I am not suprised you haven't found any. You can set PicPath to the
picture you want. I just used what came loaded onto my machine (Office
2000).

*Load a Picture as the Object Background:* 'Change Picture

Code:

 

[Shake]

Thanks for that! That works fine

I'll try toadapt it so that i can open differant pictures with maybe a
random number routine, say between 1 and 10. So that i can get files
that are named i.e. 1.jpg, 3.jpg