Error in VB code

[Lou_Reed]

I will try it. It does not say to do that in the instructions that I have.



Respectfully,


Lou Reed

[Lou_Reed]

Here is what I got when I included the ? in the command.

?VerifyCreditAvail 5.0, 4.93
5, 4.93
5, 4.93

It is just a printout.
I was expecting the dialog box telling that there was insufficient credit available.

What am I doing wrong?


R,

Lou Reed

[RuralGuy]

I haven't figured out what is going on yet but you created a "Class Module" and not a Standard Module for starters.

[Lou_Reed]

You got it right. When I rewrote the code using a standard module and the program ran with no trouble at all.

The question is what is the difference between the two modules (class and standard) and can one be changed to the other after the fact?

Thanks very much for your input.

Respectfully,

Lou Reed

[RuralGuy]

I don't believe they can be changed after the fact. Here's an article on Class Modules: http://www.cimaware.com/expert-zone/...classes-in-vba