Accessing objects by name

[jdvorak]

I Solved it! - use Me.OLEObjects("OptionButton" & CStr( i)).Visible = False

I am trying to control the visibility of several buttons using a procedure. I want to specify the buttons by name. The name is dynamically constructed at run time within a for loop. I saw the following code fragment online but cannot get it to work in my Excel macros:

Please Login or Register  to view this content.

So the first iteration would have the effect of OptionButton1.Visible = False
The second iterations would have the effect of OpetionButton2.Visible = False
And so on.

Since the code fragment doesn't work, how can I access an object by dynamically constructing its name at run time? Thanks in advance.

Joe

[Palmetto]

jdvorak,

Welcome to the Forum.
However, your post does not comply with the Forum Rules which you agreed to follow. Per Rule #3, all VBA code must be wrapped in code tags. Please edit your thread to add the code tags, after which solutions will be suggested.

Rule #3

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.

[DonkeyOte]

Thanks for posting back with your solution - this will invariably help others looking to do similar going forward
(thanks also for adding tags)