How to save Userform option button and Listbox data in a worksheet.

[Boubiche]

Hi guys,



I have a Userform that uses text boxes, list boxes and option buttons.

I have managed to save the data form text boxes to a separate worksheet in the same workbook, but I have no idea how to do the same with the option boxes and the list boxes. Basically, I am trying to save the all the data from the Userform in a worksheet, but I have no idea what VBA code to use for listboxes and option buttons.


Sheet: sheet3

Frame1: Ogest1 & Ogest2

Frame2: OProg1 & OProg2


Listbox1: ListBoxMinorite

Listbox2: ListBoxDev



Can anyone help me with that please!!!

Also note, this is my first time trying my hand at VBA, so please bear with my lack of knowledge.

 

[AlphaFrog]

Cross-posted
How to save Userform option button and Listbox data in a worksheet.

Cross posting is allowed, but you have to say it's cross posted and provide a link to the other site's post.

Here's why. Please read this...

A message to forum cross posters​

 

[Boubiche]

oh my.. i didn't even it was a thing with a name!!

Thank you so much for the FYI

p.s. How do i edit the initial message i posted. Can you please help with that, so I can add it to my message.

thanks