im kind of new to vb and excel and don't really know much about it


i basically created a database in excel with a few columns and rows, there is a command button that i included which when it is clicked shows an input form.

The user inputs data into that form and clicks a command button to have the data entered into the database.


The problem that I am experiancing is that the data is not sorted by a certain column in alphabetical order. Everytime new data is entered it just adds it into the current data without sorting it.

Is there maybe any sort of coding that I can include that will at the end highlight all of the data and sort is automatically or might there be a different solution to my problem?

Thank you