Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform.show '1004 Error'
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform.show '1004 Error'
"Stan" wrote in 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 Not sure if this will fix it, but I normally only show a userform from the calling sub. Any other actions, such as frmHub.MultiPage1.Value = 0 I would normally put in the activate event code. HTH, Alan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error 1004 (VBA) | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
VBA error - run-time error '1004': | Excel Programming |