UserForm Image

[sheeeng]

Hi all,

I know that a pic can be put on a userform by refer external pic file (eg *.bmp).

Image1.Picture = 'external link

But can I insert or import pic so that the pic is stored inside excel and doesn't need to refer external pic each time load form?

Thx.:friends:

[Bob Phillips]

Hi all,

I know that a pic can be put on a userform by refer external pic file (eg *.bmp).

Image1.Picture = 'external link

But can I insert or import pic so that the pic is stored inside excel and doesn't need to refer external pic each time load form?

Take a look at Stephen Bullen's site, http://www.oaltd.co.uk/Excel/Default.htm, and look for the PastePicture entry.

[Jacob Hilderbrand]

You can just load the pic onto a Image Control on the userform (from the Properties Window) and it will be stored with the spreadsheet (and will also add to its file size).

[sheeeng]

Thx all,
I appreciate all your help.