Making VBA more like .net – Global Constants By Etienne Bley August 29, 2014February 3, 2022 Some tips understand scope in VBA – this is NOT VB.net perhaps use global variables and use _CAPS so they are readily identified put them in their own VBA module