disect 6 digit serial....

[Synergy.ron@gmail.com]

can public functions only be in a standard module?Thanks. your procedure works well...

[wvmitchell]

can public functions only be in a standard module?Thanks. your procedure works well...

Hi Ron, besides a standard module, you can use a public procedure in a form module however 1) the form has to be open, 2) the code has to be declared Public Function (or Public Sub). HTH