How to code actions to happen when a userform.show event occurs

**Osprey2** · 10-03-2023, 10:56 AM

I have used the following code to ensure that my two option buttons are in the required state every time a userform is shown.

Please Login or Register  to view this content.

This works when the app starts from cold (The first activity is userform1.show)
But on subsequent showing of the form it does not.
Is this because the initialization of the form is the wrong activity, or because the OptionButton .Value should be something other than True/False
Or something else?
The samples in the MS Help guide seem to imply that my code should work, so I'm stuck and would welcome help
John

**torachan** · 10-03-2023, 12:15 PM

What userform activity are you performing before your second case of userform1.show - if the form has been unloaded then the initialise event should perform again on show.
see big yellow banner - how to upload your workbook so that we see all code to see what you are trying to achieve.