VB Code to sort the list in ascending order

Hello:

Please refer to attached file.
I am using below VB Code to sort the list in Ascending order instantly once the Name is added in column B.

Please Login or Register  to view this content.

I am getting error.
Would appreciate help to correct the code.
Let me know if you have any questions.
Thanks.
Riz

Hi Riz,
try this

Please Login or Register  to view this content.

Hi Nilem:

Seems to work, will test more asnd let you know if any problem.

Thanks

Riz