Autocomplete In A Textbox Using Vba

I have an excel file with a large amount of data. It is used to keep track of our firms past and current projects (on each row). The columns include data such as the name of the client and the city in which the project is located.

The excel sheet is set up with filters, so that it is easy to check which jobs we've done for client 'X', for instance, or the jobs initiated since a certain date.

In order for the filters to work properly, we need to make sure that, as an example, teh client name has to always be inputed in the same manner. Using excel's autocomplete option works well for this.

New projects are added to the top of the list. So, a new row has to be added each time a new project is inputted.

In order to automate things, I've made a userform with text/comboboxes in which the data for the new project is inputted and then placed onto the sheet once the userform is closed.

My question is this:

Is there a way to have the text/comboboxes on the userform use the autocomplete feature? As an example, if I'm entering the client name for a new project, is there a way to have the textbox autocomplete the client name by checking in the client column on the sheet? And, if there is more than one client starting with the same letter, is it possible to make a listbox appear showing all the clients beginning with that letter so the correct one can be picked?

Since the list of clients will always be changing, I don't want to code a certain set list, or have to continually update a list. (besides, the amount of coding would be huge considering the number of clients I would have to give it's own .AddItem)