Custom sort with user form

[anon]

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

 

[Per Jessen]

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