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?