Richard,

Your code looks ok to me.<g

You could try removing the form, but export it first to save it.
Save the project then import the form back in.
Sometimes that can "clean" things up a little.

The other thing to check is the size of the form file.
I would suspect that if it is 50kb + then the size could be contributing
to the problem. A lot of form code can be placed in a standard
module and called from the form module.

If you have to rebuild it, you can copy the code out to Notepad
and save it. Then you just have to add new controls to a blank form.

Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Richard Finnigan"
wrote in message...
This problem is driving me up the wall I have spent ages working on a user
form and now it wont open with the show method despite the fact that the
show method appears on the drop down list after the object name.

I did not realize that VBA in Excel was such a buggy fragile environment
becasue my only explanation is that the file has become corrupted in some
way or another. I'm looking at losing weeks of work here !

Any help or suggestions would be welcome.
--
Richard Finnigan