Userform Image Control and embedded images

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

See Stephen Bullen's site:

http://www.oaltd.co.uk/Excel/Default.htm

the paste PastePicture.zip file, about 2/3rds the way down the page.

--
Regards,
Tom Ogilvy


"tim" <tim@discussions.microsoft.com> wrote in message
news:5768C03D-EFEB-449F-87A7-5F843D65AE27@microsoft.com...
> 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

Tom,

Thanks for the link, I have reviewed that in the past, in addition to JWalk.
It seemed to me that a good portion of what they were doing was creating the
picture in the first place. I was hoping that since the pictures exist
already, that loading them would be easier. I guess the short answer is to
reference the picture, copy it to clipboard or create temp image and then
load it.

Regards,
Tim

"Tom Ogilvy" wrote:

> See Stephen Bullen's site:
>
> http://www.oaltd.co.uk/Excel/Default.htm
>
> the paste PastePicture.zip file, about 2/3rds the way down the page.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "tim" <tim@discussions.microsoft.com> wrote in message
> news:5768C03D-EFEB-449F-87A7-5F843D65AE27@microsoft.com...
> > 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
>
>
>

Yes, you would only need to use the code from the point the image is in the
clipboard.

--
Regards,
Tom Ogilvy

"tim" <tim@discussions.microsoft.com> wrote in message
news:D23B15F1-A95E-4774-9B42-1C79B7379CE6@microsoft.com...
> Tom,
>
> Thanks for the link, I have reviewed that in the past, in addition to
JWalk.
> It seemed to me that a good portion of what they were doing was creating
the
> picture in the first place. I was hoping that since the pictures exist
> already, that loading them would be easier. I guess the short answer is
to
> reference the picture, copy it to clipboard or create temp image and then
> load it.
>
> Regards,
> Tim
>
> "Tom Ogilvy" wrote:
>
> > See Stephen Bullen's site:
> >
> > http://www.oaltd.co.uk/Excel/Default.htm
> >
> > the paste PastePicture.zip file, about 2/3rds the way down the page.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "tim" <tim@discussions.microsoft.com> wrote in message
> > news:5768C03D-EFEB-449F-87A7-5F843D65AE27@microsoft.com...
> > > 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
> >
> >
> >

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" <tim@discussions.microsoft.com> wrote in message
news:5768C03D-EFEB-449F-87A7-5F843D65AE27@microsoft.com...
> 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

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" <tim@discussions.microsoft.com> wrote in message
> news:5768C03D-EFEB-449F-87A7-5F843D65AE27@microsoft.com...
> > 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
>

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" <tim@discussions.microsoft.com> wrote in message
news:BFCC0D40-5B7F-4C3A-8472-7BC15590D4DF@microsoft.com...
> 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" <tim@discussions.microsoft.com> wrote in message
> > news:5768C03D-EFEB-449F-87A7-5F843D65AE27@microsoft.com...
> > > 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
> >

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" <tim@discussions.microsoft.com> wrote in message
> news:BFCC0D40-5B7F-4C3A-8472-7BC15590D4DF@microsoft.com...
> > 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" <tim@discussions.microsoft.com> wrote in message
> > > news:5768C03D-EFEB-449F-87A7-5F843D65AE27@microsoft.com...
> > > > 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
> > >
>

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" <tim@discussions.microsoft.com> wrote in message
news:07E74919-BC05-4298-B5B6-B4001C65ED98@microsoft.com...
> 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" <tim@discussions.microsoft.com> wrote in message
> > news:BFCC0D40-5B7F-4C3A-8472-7BC15590D4DF@microsoft.com...
> > > 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" <tim@discussions.microsoft.com> wrote in message
> > > > news:5768C03D-EFEB-449F-87A7-5F843D65AE27@microsoft.com...
> > > > > 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
> > > >
> >