UserForm as a Jpeg Image

[John]

Is it possible to open a worksheet with a jpeg image like you can with a
Userform in VB and impose some Text over this Jpeg. I've tried to copy and
paste in to a Userform but nothing happens

Any help would be great

John

 

[BrianB]

Could put a text box over

 

[John]

I could but how do I display the jpeg?

 

[Keith Willshaw]

Is it possible to open a worksheet with a jpeg image like you can with a
Userform in VB and impose some Text over this Jpeg. I've tried to copy and
paste in to a Userform but nothing happens

Set the picture property of the Userform to the address of the image
you want to use and the PictureSizeMode to Zoom,Clip or Stretch
as you prefer

Keith

 

[John]

I've just read an earlier post by Mark Rosenkrantz and it doesn't seem very
easy, ah well

I could but how do I display the jpeg?

 

[John]

That was easy, thanks for that Keith

John

Set the picture property of the Userform to the address of the image
you want to use and the PictureSizeMode to Zoom,Clip or Stretch
as you prefer

Keith

 

[John]

I have a password set every time my working file is opened. Is it possible
that the "password required" window would display within my Userform Jpeg.
Currently it displays before it

Thanks

John

 

[Keith Willshaw]

I have a password set every time my working file is opened. Is it possible
that the "password required" window would display within my Userform Jpeg.
Currently it displays before it

If the password is to protect the workbook the answer
is no since the workbook must be opened before
you can access the VBA project.

Keith