Calling a Sub in VBA

This my simplified script:

Sub SomeOtherSub(Stattyp As String)
‘Daty and the other variables are defined here

CatSubProduktAreakum(Stattyp, Daty + UBound(SubCategories) + 2)

Alternative to the Excel VBA Editor?

Is there an alternative to the usual Excel VBA Editor, which is accessible using Alt+F11 in Excel?

I prefer the Visual Studio IDE, such as for when I develop in C#. An example of its deficiencies for …