code won't run

[tractorvix]

This must be something so basic, but I just can't get my procedure to run. My cursor is in the procedure, I press F5 (or click on the blue play button) and all I get is a pop-up for Macros.

Am I being thick?

Vix

 

[Remou]

If your procedure is in a form or report module, this will happen. Put it in a module of its own. You will also get a pop-up if your procedure has required arguments.

 

[Remou]

Oops strike 'of its own', what I mean is standard module.

 

[tractorvix]

I've put it in a module. Still no joy.

Even this won't work


Sub PayDate(DTDate As Date)
MsgBox "Payment is due by " & DTDate

End Sub


Sub PurchaseDate(DTBought As Date)
PayDate DTBought

End Sub

Uber frustrating

Vix

 

[Remou]

What happens if you type:
[tt]?PayDate(now())[/tt]
in the immediate window?

 

[PHV]

You can't launch with F5 a procedure that expects arguments ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886