Select sort key from drop down box

With the help of people on this board I have managed to use an input box to
enter the column number to sort a range of cells. I now want to take it a
step further.
How can call a dropdown box listing the column headers so that a user can
select which column to sort by? I also need to store the column numberas
this is used in further code.

Any ideas?

Pablo,

I have supplied a suggestion in the original thread.

--
HTH

Bob Phillips

"pablo bellissimo" <[email protected]> wrote in
message news:[email protected]...
> With the help of people on this board I have managed to use an input box
to
> enter the column number to sort a range of cells. I now want to take it a
> step further.
> How can call a dropdown box listing the column headers so that a user can
> select which column to sort by? I also need to store the column numberas
> this is used in further code.
>
> Any ideas?