VBA - Userform & Image size issue

[Nikolis]

Hello everybody,

I have a userform, for which I have specified the (Height = 720) & (Width = 1280) properties from the Properties panel.
And I have made a Jpeg in Photoshop which is intended as a sidebar menu background in my userform and it's (Height = 720) and (Width = 190)

Now, one would have expected that the sidebar graphic would be covering the height of the userform all the way vertically (since they both have height = 720), yet when the userform loads there is blank space in it under the graphic and, thus, a vertical scroll bar is used. A horizontal scroll bar is also needed and the blank spaces are about 1/3 of the set userform face. Those blank spaces are white, while my userform's background is set to a light blue version.

Why is this happening, can somebody explain what I'm missing here ? Many thanks in advance !

 

[Jimmypop]

Hi there

Have you maybe tried to set the userform pic property to zoom? Not sure if this will fix your problem... Also is there any reason for the specific height and width...

 

[Nikolis]

Thank you Jimmypop for your attention and feedback.
I changed the pic property to zoom and it did ;
- solve one of the issues (no margin left after the bottom of the pic),
- limit the other one (a small white margin to the right side of the userform),
- create a new one, as the sidebar pic is now somewhat (yet notably) pixelized. I mean it doesn't take an experience eye to notice that the lower right corner is "broken".

Any further ideas ?

 

[Jimmypop]

Will investigate... could you maybe provide us a screenshot of what it is like currently?

 

[Nikolis]

Sure ... the 2 jpegs are the initial and the "after zoom" state of the userform.
Once again, many thanks !

 

[Gokhan Aycan]

1. Userform.Height is not the same as Userform.InsideHeight (should be read-only)
2. Userform dimensions are in points, not pixels.
3. PointsperPixel = 72/Display DPI
A regular 1920x1080 monitor is usually 96 DPI. Not sure if display scaling would change things.
Your userform should be more like 960 pixels (including titlebar) in height, while image is 720, which causes stretching.

 

[Nikolis]

Gokhan thank you for your feedback and attention ! Your suggestion did solve the problem, as the conversion formula you indicated leads to a 960x540 (points) userform (equal to 1280x720 pixels). It seems to fit the image perfectly well and (appearance-wise) is what I was looking for in the first place.

Also, many thanks for the .InsideHeight pass - new as I am I didn't even know this property existed. So, typically the image doesn't fit 100%, but some ... 99% also does the job for me.

Not to forget, Jimmypop thank you, too !