Userform Option Button to Show/Hide Another Option Button on same Userform

Hi All,

I have a userform that has two checkboxes - 'OBTCL' & 'OBNAS'. When the value of 'OBTCL' is true I would like it to show an Option Button 'OBLabel'. If false then hide 'OBLabel'
All the above are on the same userform - 'UserForm1'.

I have tried the following:

Please Login or Register  to view this content.

The above still shows 'OBLabel. I'm also not sure if i have put the code in the correct Sub, 'UserForm1_Initialise'?

Any help on the above would be appreciated as always.
Cheers,
Mark

The initialize event of a userform has this signature.

Please Login or Register  to view this content.

It does not include the userform name nor is initialize spelt with a s.

So that would suggest you created that routine and as you suspect it is not exectued when the userform loads.

If the only place you are altering the Visible property is in the initialize event then it will not appear as suspect the default values of the checkbox are such that the label should not appear.

You would also need to check the status of things whenever the checkbox values change. So you would need code in their change events.