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.
Define the procedure as Public.
Public Sub TestMacro()
MsgBox "This Macro Runs from the dialog"