run time error 424
 

After modifiying code written in the Initialize event of a UserForm thi
problem arises.

The UserForm is called from a commandbutton in a worksheet with th
following code and it is in this line where the error is produced.

UserForm.show

and the message problem is Error 424 run time. Object required.

The form name is spelled correct and the form is in the VBAProject
Excel 200

--
CarlosBrav
-----------------------------------------------------------------------
CarlosBravo's Profile: http://www.excelforum.com/member.php...fo&userid=1645
View this thread: http://www.excelforum.com/showthread.php?threadid=27825

run time error 424
 

Suggest you check the code in the userform, looks like that might b
what is stopping the Show.

Go to the code module and step through

--
Brian

-----------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...tinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=27825