SOLVED

Question related to Message box after sorting is done

%3CLINGO-SUB%20id%3D%22lingo-sub-2425399%22%20slang%3D%22en-US%22%3EQuestion%20related%20to%20Message%20box%20after%20sorting%20is%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2425399%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EI%20have%20created%20code%2C%20and%20it%26nbsp%3B%20works.%3C%2FP%3E%3CP%3EBut%20%3CSPAN%3E%26nbsp%3Bhow%20can%20I%20put%20a%20msg%20box%20after%20I%20sort%20the%20table%20with%20the%20help%20of%20VBA%20code%20only%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20Example%20-%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20sort%20DIVISION%20then%20it%20show%20message%26nbsp%3B%3CSTRONG%3Etable%20sorted%20by%20Division%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3EAND%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20sort%20CATEGORY%20then%20it%20show%20message%26nbsp%3B%3CSTRONG%3Etable%20sorted%20by%20Category%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAND%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20sort%20TOTAL%20then%20it%20show%20message%26nbsp%3B%3CSTRONG%3Etable%20sorted%20by%20Total%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20Help...%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20attached%20file..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2425399%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2425792%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Message%20box%20after%20sorting%20is%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2425792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2425885%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Message%20box%20after%20sorting%20is%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2425885%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20sir%3Asmiling_face_with_smiling_eyes%3A%3Asmiling_face_with_smiling_eyes%3A%3C%2FLINGO-BODY%3E
Regular Contributor

Hello Everyone,

I have created code, and it  works.

But  how can I put a msg box after I sort the table with the help of VBA code only?

 

For Example - 

I sort DIVISION then it show message table sorted by Division

 AND

I sort CATEGORY then it show message table sorted by Category

AND

I sort TOTAL then it show message table sorted by Total

 

Please Help...??

 

Here is a attached file..

 

 

 

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Zan_Hanifee 

See the attached version.

Thank you so much sir