Hello,
I wanna have an error handler that handles according to the error that happened.
for example, lets consider 3 variables:
[VBA] dim bignumber as long
dim smallnumber as integer
dim someword as string
[/VBA]
now, instead of writing "IF" code by each instance that i use these variables, i want one error handler that, if lets say the user inputs into 'smallnumber' a very large number, the error handler will jump to a section where i can simply have a msgbox that tells them they did something wrong, change it, and continue with the macro... see, i dont want to make a million 'on error goto' sections. just one, that recognizes the specific problem, and allows me to change it. Am i making sense?