Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007