Combobox VBA update value worksheet

[Admin]

Again not sure..

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

[Tony]

Again not sure..

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

Hi :D

Thanks for your help, worked exactly how it should be .

Private Sub ComboBox1_Change()

    Dim lngIndex    As Long
    
    With Me.ComboBox1
        lngIndex = .ListIndex
        If Not lngIndex = -1 Then
            [DASHBOARD!C6]= .List(lngIndex)
        End If
    End With
    
End Sub

And i set the rowsource to Scenario.. works perfect.. Is there also a way to display the current value on loading the userform in the combobox?