VBA Code to call another VBA function when certain cells match a given criteria

[arnelgp]

the sub SaveButtonAir_Click() is Private on userform CSFCollectionAir, you need to make it Public and make the userform Available, thus call it using UserFormName.SaveButtonAir_Click.
another approach is to move the bulk of the code of the button to a Public Sub/Function in a Module.