Hi Jason25 and welcome to the forum,

It seems to me you are looking for the functionality of a ComboBox instead of a TextBox. Instead of having a TextBox on your form change it to a ComboBox and then point the rowsource to a list of unique values in your Column A.

See http://www.contextures.com/xlDataVal14.html
or http://www.learnexcel.org/blog/learn...ombobox-lists/