Tony,

If the code is only to be used by that form, you can put it in the userform
module. If it is to be used elsewhere, including another form, make it
public and put it in a general module.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tony James" wrote in message
...
Hi

I am beginning to appreciate what I can do with excel and vb but I am
trying
to develop some rules for myself regarding when to put the code in a modue
and when to put it behind the userform sheet etc.

does anyone have some rules?

thanks