Combobox VBA update value worksheet

[Admin]

Hi

Not sure what do you want.

To get the selected value, try

Private Sub ComboBox1_Change()
    
    Dim lngIndex    As Long
    
    With Me.ComboBox1
        lngIndex = .ListIndex
        If Not lngIndex = -1 Then
            MsgBox .List(lngIndex)
        End If
    End With
    
End Sub

[Tony]

I cant upload the file as it is trusted, but i try to explain it:

On worksheet dashboard i have on cell E1 a combobox that is listing 3 values. When changing the combobox value the data behind will change automatically. What i try to do is create a combobox in a userform VBA that is getting the values of the combobox in cell E1 and when picking one of those values updating the value of E1 with the selected value.