Also, I guess the confusion for me is from your basic question.

When I use the property window to load an image in the userform by picking
it with the browse button, I can then save the excel file and close excel.
I can then delete the image, and when I open excel and show the userform,
the image is still in the image control. The original file is no longer
required. Thus my assumption that you needed to change the image
dynamically, thus requiring access to the image file with your work around
of putting the images on the worksheet. Where you experiencing different
behavior with reference to a static image?

--
Regards,
Tom Ogilvy



"Tom Ogilvy" wrote in message
...
The limitation is that you would never change the image in your
application.
If that is your situation, then this should work for you.

--
Regards,
Tom Ogilvy

"tim" wrote in message
...
This method is also mentioned in JWalk's XL2002 Power Programing w/VBA
(p386), albeit briefly.

Regards,
Tim

"Jim Cone" wrote:

Tim,

" I wonder what the Achilles heel is for this method."

Good question - however, I've sent add-ins, using this method,
to all parts of world without problems.

I didn't invent the technique, I believe it is Jim Rech that the
credit belongs to.

Regards,
Jim Cone
San Francisco, USA


"tim" wrote in message
...
Jim,
Hard to believe or not, it appears to do the trick. I did try
Copy/Paste
into the image control itself, never would have thought about into
the
path.
I wonder what the Achilles heel is for this method.
Regards,
Tim


"Jim Cone" wrote:
Tim,
The following is a little hard to believe, but it works...
When using an Image Control on a user form,
copy your picture - (Ctrl + C)
In the properties window for the Image Control,
paste directly into the "Picture" property - (Ctrl + V)
Set the "Picture Size Property" to Zoom.
Adjust the size of the Image Control.
Jim Cone
San Francisco, USA


"tim" wrote in message
...
Howdy,
I have created a couple of Userforms that contain image
controls.
Given
that not everyone will have the images in the same path (or at
all) I wanted
to include them on a worksheet. I have named the images, but
how
do I load
them into the Userform(s)? It appears the only way is to
navigate
to the
location on the harddrive.
TIA,
Tim