Although I can live with having a Sub run when setting the ComboBox Sub to AfterUpdate...I would really prefer it to be set to _Change. Here is the Sub code that runs after the event:

Dim fnd As Variant
    Dim tbl As Variant
    
    Set tbl = PivotTables.Range("A5").CurrentRegion
    Set fnd = tbl.Find(What:=Me.BomberNameComboBox.Value, LookIn:=xlValues)
    
    If fnd Is Nothing Then
        BomberMissionNumberBox = 1
    Else
        BomberMissionNumberBox = fnd.Offset(0, 1).Value + 1
    End If
When set to _Change...some keystrokes I can enter...other's throw an error at the Else statment. The range it is searching can be empty...or it can have entries. Doesn't seem to be any rhyme or reason for this.

If I run the same thing with _AfterUpdate...there is no problem at all.

Any suggestions?