Hi,
Rowan's answer is good. I have implemented the same macro to a userform
utility.
Here is how it works:
Click the Open Folder Picture button to show the Open Dialog
Click Cancel when you have found the Folder you want. The Open Dialog does
not open any files should you click the OPEN button.
The file types have been preset in the Open Dialog.
The Folder Location textbox shows your selected Folder of Picture Files.
The File Type combobox shows you the type of file types allowed for the
image control.
The Files in the Current Folder listbox shows the compatible files. Click an
item in the listbox to load it into the image control.
Insert Picture button inserts the selected picture into the current active
worksheet.
The Hide Pic Box button allows you to hide the main form so you can get a
better view of the inserted picture. A small form is shown at the Top-Left of
your screen so you can reload the main form when you are ready.
Also, I have resized the picture to approx. 1/3 the original size. Good for
large pictures, no good if you import an icon or small picture...
You can download it from
http://www.geocities.com/excelmarksway
(e-mail address removed)
24 October 2005