Hiding and Showing userforms - 424 Runtime Error

~Josh~ · Jan 15th 2013

Hello, greets.

I have this problem when I click a command button to go on to my second userform using the show/hide method. It worked for a period of time however suddenly it stopped working, displaying the runtime error 'Run-time error 424 - Object required'. I can't find how to change it.

Code

If LSTItem.ListCount = 0 Then
UserForm1.Hide
UserForm2.Show
End If

When I go to debug the code it comes up with this as the issue,

Code

UserForm2.Show

. Please help!

cytop · Jan 15th 2013

Re: Hiding and Showing userforms - 424 Runtime Error

You need to provide more information. At the very least, the relevant code from the userforms, but preferably a copy of the workbook that displays the problem...

**royUK** · Jan 15th 2013

Re: Hiding and Showing userforms - 424 Runtime Error

Have you changed the userform's name?

**norie** · Jan 15th 2013

Re: Hiding and Showing userforms - 424 Runtime Error

What code, if any, is in the Initialize event of UserForm2?

Hiding and Showing userforms - 424 Runtime Error

Participate now!

Share