View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_82_] Leith Ross[_82_] is offline
external usenet poster
 
Posts: 1
Default PasteFace from IPicture


Hello AMDRIT,

There are 2 ways to do this. If the IPictures are in individual file
you can use the VBA command...

StdFunctions.LoadPicture([filename], [widthDesired As Long]
[heightDesired As Long], [flags As LoadPictureConstants = Default])

Or copy the pictures to the Clipboard and use the following CommandBa
method...

.PasteFace

See VBA help for CommandBars to find the control you want to paste th
picture on.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=47837