I’m trying to simply my process to enter customers into my worksheet. I’m not sure if Excel is capable of this, so I thought I would ask for help. At this point, my thoughts are just conceptual.

I would like to have a basic UserForm with a list of customers. I would like to open the UserForm, select my customers for this order, then have the UserForm populate selected customer (in alphabet order) starting in cell D188 and going up to D263 based on the number of customer selected. I can have up-to 75-customers per worksheet. My VBA skills are limited (and that may be an overstatement), so any help or suggestions is greatly appreciated.

UserForm.jpg

I am currently using Data Validation with a Defined Name dropdown list within the range. However, there are some limitation I’ve found with Data Validation (e.g., will not auto complete as I start to type to find matching customer(s), the dropdown list only shows 8-customers, font is extremely small and cannot be changed). It time consuming to scroll through the list with only 8-customers with very small text to select each customer one at a time. So, I looking for other options.

I’m not hung up on the CheckBox or OptionButton list, it appears it would be quicker to select my customer all at once and let the UserForm populate selected customer into my worksheet (assuming that’s possible).

If you there’s an earlier or more feasible approach, I’m certainly looking for suggestions.

I do have a question and/or concern. I occasionally add a new customer. By using the UserForm with a CheckBox or OptionButton, if I add customer(s) will I have to rearrange my form to insert the customer in the appropriate alphabet sequence or can my CheckBoxes be tied to a Defined Name dynamic list and as I make changes to my list, it would update my UserForm automatically? If I would have to adjust the entire UserForm (e.g., insert customer and move others), this may become burdensome and difficult to manage...

Thank you for your help.