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

On 23 Nov., 20:44, anon <inboxalwaysf...@hotmail.com> 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