Help! I'm new at working with macros and forms in excel and I'm having a problem that I can't figure out.

I currently have the below code for one of my comboboxes.

Private Sub ComboBox_IS_Prev_Change()
If ComboBox_IS_Prev.Value = "Other" Then
other_name = Application.InputBox(prompt:="Enter Name of Previous Provider", Type:=2)
Range("E35").FormulaR1C1 = other_name
Else
Range("E35").FormulaR1C1 = ""
End If
End Sub

This macro works fine but for some reason when I do a Save As on the file, this function is running and causing the inputbox to be displayed. And the inputbox isn't displayed just once, it's displayed twice before the file will save.

Thanks!
Torri