Combox Save Index Column PROBLEM

Hello.
I am try to make a save from a combox that have 7 combox, this will be the causes from a stop machine.
On this particulary case i can choose from 1 to 7 causes from a stop, and in the End i want Save it.
I make this code but i have a problem, with this code i dont save nothing, its because the index column, but i dont know how to solve that.
See more details on the CODE

Please Login or Register  to view this content.

Hi,

You need to change the '3' indicating column C. e.g.

Please Login or Register  to view this content.

..etc...

...Sorry but I don't understand what you are asking for.

As a minimum you'll need to upload the workbook and tell us how you use it.

You'll need to tell us what you do and give us a schedule of inputs you make and what the results should be and where they should appear.

I dont know how to put in attachmente . dont work.

But send the link to the file.


https://www.dropbox.com/s/v5m0y8lz0w...0box.xlsm?dl=0

I want that if i have more then one reason for stop , in this case choose several reason all from the same column in this case Plan16 and we record it all in the same column in the Plan17

Hi,
Your OP mentioned 7 combo boxes. The file you uploaded has 6. Please clarify.

When you enter a value in each one where do you want the entry to appear. Please clearly indicate the sheet and the cell addresses.

The next time the userform combo boxes are used, where should the next entries be recorded?

You really need to offer some specific examples in a workbook. At the moment I can only guess at how you expect this to look.

Map out a schedule of entries that you make that clearly identify the value you enter, where you enter them where the results end up and manually add the results in the workbook.