I have a dream related to ImageURL

[Pertsa]

Is it possible to get the URL of an image file that’s placed on a spreadsheet using macro and use it as the ImageURL for an Image control on a Dialog box?

This does not work

[Villeroy]

Let me guess, which problem you try to solve with all that macro code.
https://www.mediafire.com/file/b4p5155c1y8bhoq/Headshots.zip/file (without macro code)

[KamilLanda]

Try:
image-from-sheet-to-dialogImage.ods (29.8 kB)

[sokol92]

In the conditions of the previous example, it can be shorter:

oImg.Model.Graphic=ThisComponent.Sheets(0).DrawPage(0).Graphic

[Pertsa]

@KamilLanda

Thank you very much. You fulfilled my dreams and brightened my day
EDIT: Your tip works brilliant, but nothing else seem to work in my tuning

[Pertsa]

@sokol92

Thanks to you too. What if multiple images have been added to the same spreadsheet?

[sokol92]

You can determine the graphic object that interests you in a cycle through the elements of the Drawpage object of the sheet.
For example, you can analyze the Anchor property, or use Name.

[Pertsa]

Thx for this.