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