Convert String To Property or Object (VBA)

Question

I am building an array in VBA for Powerpoint.

The sub sweeps through all shapes in each slide in the presentation, and I want to store into the array:

The property (as string or object)
The value of that property.

I will then load this array into a list box. When the user clicks on the selected item in the list box I want the property to be set with the value.

In code it would be something like this:

Dim s_MyProperty as string
Dim s_Value as string

'Remember the variables
s_MyProperty = ".PageSetup.SlideHeight"
s_Value = ActivePresentation.PageSetup.SlideHeight

' This is the part I need help with
' Apply the property
Dim o_Object as object ' or something similar
o_Object = ActivePresentation
o_Object &  s_MyProperty = s_Value

The code would be similar in Excel.

Any ideas?

Cool Blue · Accepted Answer · 2013-11-20 06:36:27Z

4

check out the CallByName function... its an oldie but a goodie.

CallbyName o_Object, s_MyProperty, VbLet, s_Value

answered Nov 20, 2013 at 6:36

Cool Blue

6,5067 gold badges31 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Cool Blue Over a year ago

Happy to help :q Thanks for the acknowledgement!

Collectives™ on Stack Overflow

Convert String To Property or Object (VBA)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related