show method of dialog sheet class failed - runtime error 1004

J

joe-rio

Hello,
I have a problem with a dialog box in VBA Exel. When trying to call up the
dialog box, I receive the runtime error 1004: Show method of dialog sheet
class failed. I remembet it working before, now it doesn't. The aim is to be
able to record very quickly by using dropdown and edit boxes

I use following macro's:


Option Explicit
'
Global fillflag As Boolean
'
Sub dialoogstarten()

dialog1:
Application.DialogSheets("Dialog1").Show
If fillflag = True Then
detail_factuur
fillflag = False
GoTo dialog1
End If
End Sub
'
Sub setinvullen()
fillflag = True
End Sub
'
The debug indicates "Application.DialogSheets("Dialog1").Show", but I can't
find the cause. Can somebody help me out with this?
Would be very grateful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 2147467259 (80004005) method return address of object envelope failed 2
how to get a simple macro to paste value 4
Run-time-error 1004 "ListIndex method of listbox class failed" 1
VBA - exporting serial letters to single documents 0
Why do I get VLookup error 1004 2
Assigned macro in Dialog giving error 9
Runtime error 1004: Select method of worksheet class failed 3
Runtime Error 1004 1

Top