Inputbox and Sorting data

Hi again everyone,

I am having an issue whereby an inputbox appears twice to direct my macro to sort columns.

What I am trying to do is ask the user for an single variable input corresponding to the column they wish to sort, ie. they select '1' then column one will sort, choosing '2' column to will sort, etc.

Please Login or Register  to view this content.

Do I need to set the inputbox as a variable?

Any help is very appreciated! Thanks for your time.

Jerry,
I found your code most useful to the problem I was having that was kind of related to this problem so with a bit of playing around with it to suit my needs I got it working as I wanted it to so this is a Thank You for the indirect help.

Here's the link to my problem & the solution I came up with using your code.

http://www.excelforum.com/excel-prog...ml#post2330950

Best Wishes
John