Add Items Into Combobox In Alphabetic Order

            When userform is opened ,Combobox on the userform is filled with values in Column B alphabatically.

Data are pulled into text boxes according to the selected value from the combobox.

Also,combobox is sorted in alphabetical order when new data is added and  deleted.

The id numbers (1-2-3-4 etc.) are automatically added to Column A. Id numbers are generated automatically again  when new record is added to the worksheet and  when record is removed from combobox.