Optionbutton check before uploading data userfrom

[remco77a]

Hi there,

I have a question and hope someone can help me.
In a userfrom I have added optionbuttons. I want a check to see if an option button has been checked before the form is written to the excel file.

The check goes well, but then the userform is completely closed, so that all entered data is lost.
how can I write the macro in such a way that when the ok button for uploading the data is checked or the option buttons are selected, otherwise I get a message and then come back to the completed form?

[MrChulo]

Hello remco77a,

We would need more information of your code in order to help. Normally the form values should not be deleted. You can populate forms before showing them and take values after hiding them... so there is something going on in your code that makes it behave like this...

I made a quick test and it behaves as expected.

I put this in form code window:

Please Login or Register  to view this content.

Attaching the file for your reference as well.

Hopefully this helps!

[remco77a]

Hi Chullo,

Great! thank you for your fast repaly my code is quite long, but your solution is workig for me!

thanks a lot!