iGuest 3 Report post Posted May 9, 2011 How can i define a variable in vba that it's value dont be deleted when application error occur.in modules and before Public Functions i define my variables as Public and global variables, but when an error occur in application it's value be deleted and null. Share this post Link to post Share on other sites