There are two Combo boxes in the form.
ComboBox1 is being populated from a named range - "ParticipantName". (Located in Sheet1!C2:C500)
ComboBox2 has been populated with "No" and "Yes" with additem in Form1 Initialize.
There are 3 (Three) Command Buttons - "Save", "Cancel" and "Close".
"Cancel" shall clear data in both Combo Boxes. It is done.
"Close" shall unload the Form. It is also done.
My problem is with the "Save" button.
The user will select a name in the ComboBox1 and Select "Yes" or "No" in ComboBox2.
Then if the user press "Save"; only the selected data of ComboBox2 will be written in the 26th Column (Column "Z") of Sheet1 in respective Row of the name selected in the ComboBox1.
Thanks in advance,
Bookmarks