Problem: VBA procedures do not appear in Macro dialog box
In ArcMap, trying to run a VBA procedure using Tools > Macros > Macros, but the procedure does not appear in the list.
Procedures defined as private can not be run as macros.
Solution or Workaround
Define the procedure as Public.
Public Sub TestMacro()
MsgBox "This Macro Runs from the dialog"