VBA cannot be used to develop standalone applications.

It is always hosted in some application, and typically used as a "macro language" for automating actions. The user must have the application installed in order to make use of any VBA you have written for it.

Some such applications offer an SDK that contains a runtime subset of the standard application. This usually requires that you acquire a developer license through some process. MS Office used to have a Developer Edition for this. Now Microsoft sells an Office/Visual Studio add-on called VSTO/VSTA (name varies with the version).

You'd have to get such an SDK from the supplier of AutoCAD. This may provide a way to create stand-alone applications that incorporate your VBA logic.