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

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 own hand at VBA, so please bear with my lack of knowledge.


please note that this is posted on another forum (i cant post the URL yet because i am new here.. but i will keep you posted if there are any developments.)

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

It would be similar to saving the text from your Textbox. OptionButtons and Listboxes have a Value property

Please Login or Register  to view this content.

The Value would be TRUE or FALSE

Please Login or Register  to view this content.

The Value would be the text of the selected item

Alternatively for the Listbox, you could save the ListIndex number if the list is always the same. Each item in the list is numbered (indexed) 0 to n. The .ListIndex property returns the index number of the selected item in the list.

Please Login or Register  to view this content.

An index number of -1 means no item in the listbox is selected.