Hello,
I'm wondering if there's anybody who has encountered this same issue.
I'm building a simple tool for data registration. I have designed my user forms and build them in Excel 2010 using the VBE.
During testing I noticed I forget to do a check when entering a new userID, to make sure there are no double userID's.
I figured I could do the check with a VLookup. I entered the code and run it. Got an 1004 error, and examined my code to see if I made an error.
I noticed something odd. Whenever I assign a variable, the Variabletype displays with a Capitol (vb: Dim test As String), however this was not the case for the added range variable (Dim r As range). I tried to change this but it kept returning to lowercase. This only happens with the range variable. When trying this in a new file, it doesn't, so it must be something with the existing file, but I be ****ed if I know what has happened. Any other variable type can be added without this issue.
I'm not sure if this would be a problem in execution of the code, but the code does work in another file (from which I actually copied it), so I'm led to believe it is an issue...
Any thoughts on this?
Thanks in advance!
I'm wondering if there's anybody who has encountered this same issue.
I'm building a simple tool for data registration. I have designed my user forms and build them in Excel 2010 using the VBE.
During testing I noticed I forget to do a check when entering a new userID, to make sure there are no double userID's.
I figured I could do the check with a VLookup. I entered the code and run it. Got an 1004 error, and examined my code to see if I made an error.
I noticed something odd. Whenever I assign a variable, the Variabletype displays with a Capitol (vb: Dim test As String), however this was not the case for the added range variable (Dim r As range). I tried to change this but it kept returning to lowercase. This only happens with the range variable. When trying this in a new file, it doesn't, so it must be something with the existing file, but I be ****ed if I know what has happened. Any other variable type can be added without this issue.
I'm not sure if this would be a problem in execution of the code, but the code does work in another file (from which I actually copied it), so I'm led to believe it is an issue...
Any thoughts on this?
Thanks in advance!