View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
nath nath is offline
external usenet poster
 
Posts: 57
Default Userform.show '1004 Error'

Try showing the form before you address an onject on it.

Nath
-----Original Message-----
Hello All,

Ok, this is quite a strage question, however I have

experienced this problem
and so has a colleague of mine for a different

application.

The problem:
Upon clicking a button in order to show my form, I get

the '1004'
Application Error.

As of Friday, I had tested it to ensure all was working

and it was. Previous
versions of the tool I'm developing work fine with

Exactly the same coding.
Hence I'm very confused. The code I've been using to show

the form is:

Private Sub CommandButton1_Click()

frmHub.MultiPage1.Value = 0
frmHub.Show

End Sub


Has anyone else experienced this problem or know of

bugs/fixes for it?

Thanks

Stan
.