Hi,

I'm looking for my users to be able to do a 'sort' function on the
activesheet.

I have custom toolbars so will add a custom button 'sort'. This will
open a custom userform (which I am intending to be similar to the form
opened by clicking on sort on a std excel menu). I want the userform
to have three combo boxes to select sort order - eg. sort by, then by,
then by....

I can create the userform however am unsure on a few things;

1. How do I assign values to the combo boxes - I know how to do this
via code but as the values will not change I can't see why I should
use code. This is a stupid question but do not know how to do it via
the properties of the combo box

2. Can I set the values selected by the user in the combo boxes to
variables and then use these in my code to perform the sort? Is it a
simple
dim val1 as string
set val1 = combobox1.value
??

3. Can I add a further level to my user form where a user can choose
to exclude certain rows of data from the sort? So if ticked these rows
would be moved to the bottom of the selection and excluded from the
sort area.