UserForm as a Jpeg Image

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
John said:
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
Click to expand...

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
 
That was easy, thanks for that Keith

John

Keith Willshaw said:
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
Click to expand...
 
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
 
John said:
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
Click to expand...

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
 
Back
Top