LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Insert Picture using Macro & Validation list

Hi,

I have an excel file and in Cell "L21" I have a Validation list that
contains Picture names I want to see if I could place a Macro that
every time I select a picture name from the Validation list macro
would look into a folder (C:\Temp\Pix\) that contains all the pictures
(some .jpg, .gif. etc.) and insert it in cell "L10" and resize the
picture to Height 42 by keeping the Aspect Ratio. If no pictures were
found insert default picture called "NO Pic"

Thanks,
Marc
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert picture using Macro.. [email protected] Excel Programming 15 June 21st 08 12:48 AM
Insert picture with macro Esrei Excel Programming 2 August 21st 07 02:20 PM
Insert Picture Macro. scottybalotty Excel Programming 0 February 15th 06 10:05 PM
Insert Picture Macro SamDev Excel Programming 5 September 9th 05 07:09 PM
INSERT PICTURE IN MACRO Glenn Excel Programming 1 April 23rd 05 11:49 PM


All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"