Format all controls/objects within frame

[asha3010]

Greetings,

I have a userform with several frames. Frame1 has several optionbuttons. The other frames contain either a textbox or combobox or both. By default all frames except Frame1 are disabled. Any frame will be enabled based on the optionbutton selection in Frame1. Once enabled, I would like to know if it is possible to change the backcolor of all controls within the frame. I believe frame is a type of container control but i don't know how to use this attribute while writing a code.

As always, grateful for any assistance.
Asha

[romperstomper]

The Frame has a controls property:

Please Login or Register  to view this content.

for example.

[asha3010]

Thank you romperstomper for providing an example based on which I put together the following code.

Can you please check if the code can be made more efficient?

Please Login or Register  to view this content.

Many thanks
Asha