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

Boubiche

New Member
Joined
Jan 27, 2016
Messages
12
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.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Boubiche

New Member
Joined
Jan 27, 2016
Messages
12
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,243
Messages
5,595,027
Members
413,960
Latest member
ikkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top