VBA to Find the Top 10 Values, Top 5 Values or Top 3 Values

This Excel VBA example explains, how to find top 10 values, top 5 values or top 3 values in excel automatically with simple programming. Use IF Condition and For Loop to loop through each cell in a range to develop macro to find top 3 values, top 5 or top 10 values in MS Excel.
Download Code at below location :

[tannertucker]

This is excellent. How does one perform the same for different selections please? Thank you.

[jaganpandya]

This is not working when duplicate values are there. Please how to do that explain. Thanks! @Excel Destination

[deva]

Sir is it possible find largest 5 values in a column and copy the corresponding 5 rows to another sheet using VBA. if so how?

[abdel-fattahmaghari]

I hope to learn how blink in textbox on user form based on condition

[sridharkrishnappanavanerth]

Sir, i am getting ' Application -defined or object -defined error ' in set myrange line. How to fix this error.

[vijaysahal]

sir what about my queries before few days