| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show method (Error 438)
HI there,
I'd like to show my form, but I get a 438 error (Object doesn't support this property or method) (it was working before, though) Public Sub rptTotalNetAssets() If LogonDB = False Then Exit Sub frmTotalNetAssets.Show ' where I got above error msg End Sub Would you guys help me out. Thanks, Lee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show method (Error 438)
Show is a method of a form so I am not 100% sure what is going on here. Does
your code have option explicit at the top of the sheet / module? Does your code compile? That is where I would start... "Lee" wrote: HI there, I'd like to show my form, but I get a 438 error (Object doesn't support this property or method) (it was working before, though) Public Sub rptTotalNetAssets() If LogonDB = False Then Exit Sub frmTotalNetAssets.Show ' where I got above error msg End Sub Would you guys help me out. Thanks, Lee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show method (Error 438)
looking at the name of the form (frmTotalNetAssets) seems to me that it
is not an excel form but a access form... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SaveAs method error | Excel Discussion (Misc queries) | |||
| forms that suddenly wont appear using the show method in VBA a bug or a corrupted file perhaps ? | Excel Discussion (Misc queries) | |||
| Show method stops macro | Excel Programming | |||
| Using Add Method of QueryTables gives error | Excel Programming | |||
| why error for activate method | Excel Programming | |||
Linear Mode
