Passing name of shape to custom function

Help! This has been driving me mad for too long. And it should be stunningly simple but I cannot get it right.

What I want to do is create a custom function that will allow me to pass the name of a shape to it so that I can then pick up the text in it. So for instance I have shape opt_P1 and I'd like to pick out the text in it using a formula. Something like:

Please Login or Register  to view this content.

Or something like that - seeing as it fails miserably if I use =get_box_state(opt_P1).

Any tips to get me out of my own hell?

Obviously : as your actual code passes the shape in variable 'box' so just use this variable to refer this shape ‼

If you really just want to pass the name, so a string then obviously set the variable as String !

But as any shape is attached to a worksheet, so if you just pass the name do not forget to hard code the worksheet before Shapes …

I think this si what you mean:

Please Login or Register  to view this content.

If so that still gives a #VALUE error. So there is something wrong in my get_box_status line. I cannot figure out what it is though. Is it missing the reference to the worksheet or something?

So the error comes from the codeline calling this function …

Andy

Bang on. Looks like it was the type for the name that was causing me the issue. Live and learn. Cheers.