Hiding Rows and Conrols simultaneously

[emilemil22]

Hello,

I am making a form and I want whenever a value of "yes'' is selected from dropdown list then certain rows along with controls appear (which have been already created).

and whenever a value of "no'' is selected from dropdown list then those rows along with controls disappear.

I tried the .Hidden function on VBA but is seems that it makes my controls unfunctional!

Thanks a lot for your help!

 

[lrobbo314]

Try using the .Visible = true, .visible = false, for your controls.