What I generally try to do is use the controls on my user form to call
procedures from the main code module. That means that the main code module
contains the heart of the program while the user forms provide an interface
for users. What it boils down to is how you write your code and how it best
suits your purpose. It is the end quality product that counts.

"Gazza" <mallin"nospam" wrote:

I have a user form which I want to use to sort data on a worksheet (having
defined a name for the data rnage). There are 2 frames on the user form. The
first frame has 3 options buttons which I want the user to decide from the 3
columns which to use as the sort (using the relevent row header). The second
frame has 2 option buttons which the user can use to determine whether the
sort is ascending or descending.

will the code that does all this need to be written in a general module or
should it be written as an event on say a "run button" on the form

Thanks

Gaz