Do you mean by this that you want the content of other pulldowns to be set
according to the selected value of one?

ScottP was telling us:
ScottP nous racontait que :

Build your userform, then for each drop down where you want the same list,
use the control's tag property. In this example I used  a tag named "MyDrop"
(In the property windows in the VBE, each control you select has a Tag
property. In fact, you can select all the dropdown you want to at the same
time and enter the tag value only once for all of them.
Finally, in the initialize event of the userform, try some code like this:

'_______________________________________
Dim MyCtrl As Control
Dim MyArray As Variant

MyArray = Array("Select an item", "Item 1", "Item 2", "Item 3", "Item 4",
"Item 5", "Item 6")

For Each MyCtrl In Me.Controls
   If MyCtrl.Tag = "MyDrop" Then
       MyCtrl.List() = MyArray
       MyCtrl.ListIndex = 0
   End If
Next
'_______________________________________