Vba code for ComboBox UserForm

[Big Lar]

A UserForm on my WS provides four ComboBoxes populated with a list of names in ColumnD
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Help needed to code CommandButton1_Click()...insert the four ComboBox values into cells AB2:AB5

Thanks

 

[doofusboy]

You mean something like this?

Private Sub CommandButton1_Click()
    Range("AB2").Value = UserForm1.ComboBox1.Value
    Range("AB3").Value = UserForm1.ComboBox2.Value
    Range("AB4").Value = UserForm1.ComboBox3.Value
    Range("AB5").Value = UserForm1.ComboBox4.Value
End Sub

 

[AlphaFrog]

Private Sub CommandButton1_Click()
    
    With Worksheets("Sheet1")
        .Range("AB2").Value = ComboBox1.Value
        .Range("AB3").Value = ComboBox2.Value
        .Range("AB4").Value = ComboBox3.Value
        .Range("AB5").Value = ComboBox4.Value
    End With
    
End Sub

 

[Big Lar]

Thanks.
I was just over thinking the process.