Sort function does not correctly reference the answer from the input box.

Use Application.Inputbox, with Type:=8

Please Login or Register  to view this content.

TRy setting it up this way.

LeapingLizard I am not understanding your advice, sorry. I am a novice with VBA.

To clarify, I am attempting to sort data from left-to-right based upon row2 using a dynamic value which is entered by the user through the input box. The issue is linking the answer from the input box to the custom sort.

I can do this sorting manually but I need to incorporate this into a larger macro which can handle many operations.

The issue is designating the "Answer" in the sort criteria. I am unsure of the format. See below.

Please Login or Register  to view this content.

If for example I use the following, the macro runs with no issues.

Please Login or Register  to view this content.

The problem is the turning the format "GGG" into the 'Answer'.

Thanks!

Can you provide a sample workbook with data and your sort macro (the one that works and the one you are trying)?

Please also explain what you are trying to achieve with the CustomOrder

Hello Jeff,

Thank you for your assistance.


This is the code that works.

Please Login or Register  to view this content.

This is the code that does not work.

Please Login or Register  to view this content.

I want to sort all the columns based upon Row2 using a custom sort of "GGG". I know I can do this manually but this is one part of a much larger macro which I am putting together.

After several several attempts to find a solution I just could not. I placed a message with the other forum members, but not luck so far.

Once you see this, if there still is not a hit you can bump again.

perhaps

Please Login or Register  to view this content.