MsgBox

[jostrep]

Can someone please help me with the following msg box.

When i click on a button which run an "import form excell macro".
I want a msgbox Vbyesno to appear before the macro is run.
The Vbyes = run the macro
The Vbno = exit the procedure (do not run the macro and close the msgbox).

Can someone please post some code, i got some element down but cant seem to get it to do the job

Tnx in advance.

 

[Travis]

Dim Response As Integer
    Response = MsgBox("Your Question", vbQuestion + vbYesNo, "Your Title")
    Select Case Response
        Case vbYes
            'Run Macro
        Case vbNo
            'Exit Sub or Function
    End Select

 

[jostrep]

Thank for your prompt reply, i surely appreciate it, gonna try the code , keep you posted.

Jos

 

[jostrep]

One last thing about the run macro... whats the precise command line? The macro is callle "importCOmain"

Thanx again

Jos

 

[Travis]

docmd.RunMacro "importCOmain"

 

[jostrep]

Thanks

Sorry for the delay everything seems to work great,

Thanks again