Inventor VBA to sort Excel before reading info

Inventor VBA to sort Excel before reading info

floccipier
Advocate Advocate
526 Views
1 Reply
Message 1 of 2

Inventor VBA to sort Excel before reading info

floccipier
Advocate
Advocate

Hi, 


I have bit of code that reads information from excel and fills in VBA form/text boxes. I need to sort the range A3:G15 based on values in G in ascending order. 

 

Thanks. 

0 Likes
527 Views
1 Reply
Reply (1)
Message 2 of 2

WCrihfield
Mentor
Mentor

Hi @floccipier.  Here are a few links on the subject that may be helpful.

https://docs.microsoft.com/en-us/office/vba/api/excel.range.sort

https://docs.microsoft.com/en-us/office/vba/api/Excel.Sort 

https://www.automateexcel.com/vba/sorting/ 

https://excelchamps.com/vba/sort-range/ 

https://excel.officetuts.net/vba/sort-range 

 

If this solved your problem, or answered your question, please click ACCEPT SOLUTION.
Or, if this helped you, please click (LIKE or KUDOS) 👍.

If you want and have time, I would appreciate your Vote(s) for My IDEAS 💡or you can Explore My CONTRIBUTIONS

Wesley Crihfield

EESignature

(Not an Autodesk Employee)

0 Likes