I don't see why you'd want to add that code to a userform, since it already runs automatically when the worksheet is changed. Still, if that's all you want to do, simply call it from your userform, passing whatever range you want to use as the target.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]