ListBox not updating after Save button

Greetings,

Another newbie: I have a userform (Userform1) with a listbox, comboboxes, textboxes, and 6 groups of radio buttons (opt1 and opt2 in groupname "Car"; opt3 and opt4 in groupname "Bus"; etc.) and 5 command buttons "New", "Save", "Delete", "Cancel" and "Edit". My worksheet has 13 columns of data and 100+ rows. I have been successful in populating the listbox with row data getting the controls located on the userform to display in their respective values when a user selects a row from the listbox. My problem is after the user edits the data to any of the controls, I am unable to get the edits to change on the worksheet and unable to get the listbox to show the changes in real time when the user clicks the "Save" button.

I was able to find some code to do exactly everything that I am needing but it only has textboxes on the userform (see attachment). I am totally clueless on how to modify this code to include comboboxes and option radio buttons. Using the sample attachment code, I have tried the following but to no avail.

Please Login or Register  to view this content.

I can get the textbox updates to work fine but the option buttons and combo boxes are not updating on the worksheet nor on Listbox1. I originally tried

Please Login or Register  to view this content.

But doesn't seem to recognize a comboBox or Option Button as controls in Excel VBACode so I change it to TypeName(ctrl) = "ComboBox" Or TypeName(ctrl) = "OptionButton" Then...

Do you have any suggestions on how I can go about modifying the attach sample code to include reference to the comboboxes and option buttons on my userform? Again the sample attachment is doing everything that I need to do. Any assistance or advice is greatly appreciated. Thank you in advance.

Hello again,

Is there not anyone out there that can help me with this issue? I have researched the forum and users with a similar situation also did not have a thread response. I really appreciate any guidance or assistance from anyone out there. PLEASE HELP ME and thanks so, so much in advance

Hi Newbie,
Just a small point. You refer to a spreadsheet but you have supplied a word document for evaluation?
IGEDIT

Thank you IGEDIT for the observation. I was just supplying an example of the userform I am trying to emulate and the code associated with it. However, with a lot of trial and error, I have fixed my part of my problem regarding the option buttons and getting the listbox to update. I am still having problems with if the user makes a change in a combobox, I runtime error 380. Now trying to figure what the problem is.

Blackbeginnings,
Glad to hear that you have made progress with your problem, solving your problems on your own is often(but not always) the best way to learn. My only point in my original post was that it is usually better to supply a work sheet with code for others to evaluate and help. It's far easier and quicker for the experts(not me) to give their advice/help.

Blackbeginnings,
Glad to hear that you have made progress with your problem, solving your problems on your own is often(but not always) the best way to learn. My only point in my original post was that it is usually better to supply a complete work sheet with code for others to evaluate and help. It's far easier and quicker for the experts(not me) to give their advice/help.
Regarding error 380, this is normally caused by referring to a list item which isn't there, Such as running a loop through a list box contents incorrectly e,g,

Please Login or Register  to view this content.

Plenty of examples on the web