Only visible CB set a value

[otrava18]

Hello,

I have a Userform with 100 Comboboxes (like a matrix 10 x 10). I want to have another 10 to modify 10 CB from matrix in the same time but only visible ones. I need to have something like that : when ComboBoxA is modified, which CB from ComboBox1 to ComboBox10 is visible, to have the ComboboxA value. ComboBoxA to be like a column head. I don`t know how to do that. Can you give me a solution ?

Thank you !

 

[SQUIDD]

Hi

IF I UNDERSTAND CORRECTLY?

So on userform activate, i would set all the comboboxes to
.Visible = False
excpet the 10 header ones.

Then code the change event of the main Header comboboxes.

like as an example

Private Sub ComboBox1_Change()

Me.ComboBox2.Visible = True
Me.ComboBox2 = ComboBox1.value
Me.ComboBox3.Visible = True
Me.ComboBox3 = ComboBox1.value
Me.ComboBox4.Visible = True
Me.ComboBox4 = ComboBox1.value

End Sub