declare global variable in vba macro. There are any references about declare global variable in vba macro in here. you can look below.