Dynamically Added Control

[BobT]

I am building a form that dynamically adds a frame and set of radio buttons.
The number and name of the buttons will vary depending on how many cells are
filled in. What I want to do is then add some code to these radio buttons at
run time.

How do you add code to a control that is added at run time? The code I want
to attach to the control will, obviously, be written at design time.

Thanks in advance.

 

[Norman Jones]

Hi Bob,

See the methods used by John Walkenbach at:

http://www.j-walk.com/ss/excel/tips/tip76.htm

 

[Tom Ogilvy]

Same site, but I would recommend this as an alternate approach:

http://www.j-walk.com/ss/excel/tips/tip44.htm

Just be aware that it won't work with Events provided by the control object
such as Exit, Enter, BeforeUpdate, AfterUpdate - only those native to the
OptionButton.

 

[Dave Peterson]

Have you thought about designing the userform for the worst case scenario?

Hide the buttons/frame/whatever. And only show what you need. Depending on
what you're doing, it may make your life a bit easier.