How can I use my own VBA public function in User-Property in my Shape ...

[WieSo_Zeigen]

Hello everyone,
I'm trying to solve the following ...please See the screenShot. Unfortunately I always get an error message.

I am still a beginner and have not yet found the right search terms for what I want to do.
I want to determine the current page height / width with a formula and then use this in my shape for further calculations.

Unfortunately I always get an error message:
What am I doing wrong?

An example would help me. Where can I find such examples?

Thank you in advance.

[Paul Herber]

=ThePage!PageHeight

[Paul Herber]

You can access VBA (macros) but you can't return any value back to Visio.

[WieSo_Zeigen]

Hi Paul Herber
Oh my God. It was really easy.
Thank you very much for your quick help.

I have a little hard time with VBA. But I think that I can still cope with it. It's been a very, very long time since I last developed something with VBA. Are there any books for this, except Microsoft Help?

I actually prefer to work more with C #.

Thank you again and greetings from Germany, Frankfurt am Main.

Frank

[Paul Herber]

VBA is horrible. C# is good though.
Glad to be of help.

[wapperdude]

... but you can't return any value back to Visio.

Whaaat?

[wapperdude]

VBA is horrible.

It's not thaaaaat bad.    😱 😨