"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

This problem was solved (hopefully) by taking the code out of the form
initialize event and putting the same code in the form activate event
....what's odd is that the form went gradually faulty rather just not working
straight away so testing the form did not show up any issues. formname.show
worked initially with the code in the form initialize event.

Strange......

Richard