Custom sort with user form

  • Thread starter Thread starter anon
  • Start date Start date
A

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
 
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
Click to expand...

sort1 = Userform1.Combobox1.Value
 
Back
Top