set global variable in excel vba. There are any references about set global variable in excel vba in here. you can look below.