Hello Simond,
Thanks for getting back to me so quickly.
The crashing occurs when I'm in the VBE and I've decided to save my work.
Clicking Save in VBE immediately shuts down the application with no warning or error message.
My knowledge of VBA comes from tracing macros and reading the result so I have to ask the simpletons question - what do you mean by 'data initialisation'?
FYI regarding my syntax problems:
I have found by trial and error that a macro written eg:
Sub pjpBubbles()
pjpBubbleForm.Show
End Sub
gives rise to an "Automation Error" and fails.
However when written so:-
Sub showpjpBubbles()
pjpBubbleForm.Show
End Sub
it works as needed!
Thanks very much for your help with this.
Bookmarks