Image quality in userform

[Formula11]

I have a spreadsheet from where I need to refer to about 20 diagrams.
Was going to load each diagram onto a userform, because I need to read cells and diagram at the same time.

The issue with images in forms is that the quality is not great, and difficult to read text in image.

Was looking at the file types when loading an image and there is *.wmf and *.emf available. There are vector image types and quality is the same at any resolution level. The file size goes from 76kb (jpg) to 2650kb (emf). The quality is not improved at all though when emf is loaded to form.

Is there anyway to improve quality so as to read text in image?

 

[patricktoulon1]

hello jaafar Tribak
i see your code for the image in userform
since 64-bit copymemory has a latency problem because the lenb is asynchronous you must always vary the lenB
because successive calls end up shunting the memory
and sometimes crash excel
It's a nice sketch in any case, well done

so well done for the scroll not in (recurse function loop in addressof) :i'm never see that

 

[patricktoulon1]

it's slow because the scroll is not in addressof
it's work in looping(do/loop)
in addressof it is not taken from the memory process stack of the Excel instance executing the code

 

[Formula11]

firstly

 

[Formula11]

Jaffar, thanks again for attempting to include Zoom and Pan for image in a userform (post #20).

Starting again, I did try it and it does work, but haven't tested with other additions such as resizing form (maybe this feature will be removed).
The speed is OK for small images. If there is an issue with crashing Excel as patricktoulon1 suggested in post #21, that would be the only worry, otherwise the speed is OK.

Did not think it would be possible get to this point actually.