View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_225_] Leith Ross[_225_] is offline
external usenet poster
 
Posts: 1
Default Auto Userform Picture Change


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:
--------------------

PicPath = "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Sunset.jpg"
UserForm1.Picture = StdFunctions.LoadPicture(PicPath)

--------------------

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=482414