Custom sort with user form
 

Hi,

I have a sheet with custom toolbars so users cannot use the standard
data - sort command (there is a valid reason for doing this).

I want to re-create something similar to the sort command.

So.

User selects customer toolbar button (done) called sort
This opens a user form similar to the sort user form
The user's selections of sort order from the form are passed to a
macro to run the sort

I am unsure how to pass the values to the code to do this as I have
not worked with user forms before. Is it as simple as
dim sort1
sort1 = combobox.value

Custom sort with user form
 

On 23 Nov., 20:44, anon wrote:
Hi,

I have a sheet with custom toolbars so users cannot use the standard
data - sort command (there is a valid reason for doing this).

I want to re-create something similar to the sort command.

So.

User selects customer toolbar button (done) called sort
This opens a user form similar to the sort user form
The user's selections of sort order from the form are passed to a
macro to run the sort

I am unsure how to pass the values to the code to do this as I have
not worked with user forms before. Is it as simple as
dim sort1
sort1 = combobox.value

sort1 = Userform1.Combobox1.Value

-----

Per