Hello! I am having trouble passing an array of objects to a subsequent sub.
I want to do the following. Sub 1 works fine, but sub 2 does not. Both are activeX buttons.- Sub 1: Create 5 activeX option buttons in the worksheet
- Sub 1: Construct an array, each array element containing one of the option button objects
- Sub 2: Goes through the array and see which one is selected
Sub 1
here's the problematic part
I have three questions
1. Will the oleObj() argument be accessible? And how do I pass it if the sub is called by a button
2. If executed from VBA, error results (as if the variable isn't there)
3. I can't check the actual function, is obj.object.value=1 the correct way of checking whether a radio button is pressed?
Thank you so much in advance, and sorry if the question is really dumb
Bookmarks