Combining 2 combobox value together but do not repeat twice if value is the same

[Chrispelletier]

Hello,

I am using a userform with comboboxes to collect information from the user. The user can decide to enter only 1 set of data which consist of 4 comboboxes (combobox #1-4). However, the user can also provide an optional 2nd set of data which repeat the same questions as the 1st set of data and use combobox #5-8. I would like then the data to be inputted into the worksheet when the user click on the button and that this data be group together under a single cell for each of the same question: for example combobox #1 and #5 are put into the same cell B2, combox #2 and #6 in cell C2, etc. I was able to accomplish that.

My problem is that I would like to group together only the data for the 1st and 2nd set of data if they are different. So if the answer to combobox #1 and #5 are the same, I don’t want them to be repeated twice in the same cell as there is no need for that (I just want 1 of the same answer) but if the answer of combox #2 and #6 are different then I would like to see those 2 different answers in the same cells.

I have included a sample file as well as the part of the code below and in red where I believe where it needs to be updated. Thank you for your time and help!

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.

[Chrispelletier]

Please Login or Register  to view this content.

Hello Mehmetcik,

Thank you for your help and time. It is working but I had to modify part of the code to show +4 instead of +1 (FYI, see correction in red below). Thank you so much for your quick response and help, greatly appreciated! I will mark as solved.

Please Login or Register  to view this content.