Variable not defined error when I have defined the variable

[jeffadkisson]

I am having an issue where I am getting a "variable not defined" error but the variable has been defined (and defined correctly). VBA even autocorrects it when I input a lower case letter so it is definitely recognizing the variable but for some reason cannot compile when I run the macro. I had no issues with this document until recently but I have been adding code of the last few weeks. Anybody seen this issue before or have any suggestions to fix? The declaration and defining variables portion so my code is below. I get this same error for all the variables.

Please Login or Register  to view this content.

[Tinbendr]

When you declare variables on the same line;

Please Login or Register  to view this content.

The first one is declared as Variant, not a Long.
The correct way on the same line:

Please Login or Register  to view this content.

[jeffadkisson]

David,

Thanks for the help. I went through and did this and it is still not picking up any of my defined variables. I have 2 other userforms that have this same code that have no issues so I am not sure what is happening with this one. It almost seems that I have somehow disabled the ability to dimensionalize variables. Is that even possible?

[vandan_tanna]

what is not defined?

for example

Please Login or Register  to view this content.

are you getting error because txtDate2 is not defined? (add watch for txtDate2 to find out)

[jeffadkisson]

No. I am sorry - I realize my post is a little confusing.

I have dimensionalized Date1 as a date but when I go to run the macro I get an error stating "variable not defined" with Date1 highlighted. So it is not recognizing Date1 as a defined variable.

[vandan_tanna]

can you upload your file so we can help more effectively?

[jeffadkisson]

Sure. Here is the full code. I have a userform that people are inputting data. This particular code goes with a command button that enters downtime information from a manufacturing process into an Excel spreadsheet. I get a error message stating "variable not defined" for every variable I have defined. I tried commenting out one variable at a time to see if the other variables would work but I get the same error for all.

Please Login or Register  to view this content.

[vandan_tanna]

Nothing obvious comes to mind except may be type conversion error.

does changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

help for this one particular variable? If it does, you might have to type cast all variables (it is a good practice anyway)

if not, can you upload your entire excel file? If you can't for proprietary reasons, let me know, and I will ask brighter minds to look.

[mikerickson]

I have 2 other userforms that have this same code

Have you defined each of the variables in each of the code modules (1 code module per userform)?