User Defined type not defined error

**Rodeoclown** · 09-26-2010, 05:16 PM

I keep getting a VBA error of "User defined type not defined. It shows up when a value is entered in the B column and a directional key is used to select a different cell. If a value is entered and the mouse is used to select a different cell it doesnt seem to error out. There are only two code modules that I have looked through but I cant find anything wrong with them. The modules are to print certain ranges and should not have any bearing on the value of the B column. Any help on a fix is greatly appriciated!

Thanks

**pike** · 09-26-2010, 05:29 PM

Hi Rodeoclown,
Have you read the definition in the vba help files?
could be error in module

**Leith Ross** · 09-26-2010, 08:02 PM

Hello RodeoClown,

I get that message more often than I would like because I am a bad typist. When I get this error it usually because I have misspelled a Data Type (Integer, Long, Variant, etc.) in a Dim statement or after a Set statement.

**atrushwo** · 02-17-2011, 11:55 AM

Hi Rodeoclown, I've been getting the same problem. I have a number of routines that run without errors and finish with no warning messages. However, once the code has been ran, I get the "User Defined Type Not Defined' error when I try to change the contents of any cells.

I have no idea what's going on. I've scoured the internet. Have you found a solution?

**pike** · 02-17-2011, 06:10 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.