Sorting Macro

[michaeljoeyeager]

Friends,

This is a small portion of a large worksheet I have going...
fasd.jpg

I have a userform that allows a user to select a sort criteria like "Ascending Price" etc.

Upon OKButton click I need a Macro that will shift the rows around accordingly.

I don't even know where to start with getting this done... Any suggestions would be greatly appreciated.

Thanks,


Mike

[arlu1201]

Its better to attach a sample excel file instead of a jpg.

[GaidenFocus]

So you have created this user form already? If so youll need the name of your text box. Then make an OK button double click it. This code will execute when the user hits 'ok'. The easiest way to make a sorting macro is to record it.

1. Go to view
2. the very right should say macros, click the little arrow below it
3. click record macro and name it
4. while recording select the range and then do a sort int he data tab.
5. stop the recording
6. put the sort macro into the OK button code, change the criteria to textbox.txt (make textbox the name of your text box)

[michaeljoeyeager]

My apologies, Arlu

Thanks Gaiden, I got it figured out.