I have a long list on sheet 1 called Activity.
I have a combo box on Sheet 2 to reference the Names in the list Activity.
I want to be able to type in the combox the first letter of the name and it narrows down the choices. Then when I type in the second letter of the name it narrows the choices even more. The more of the name I tye the less choices I have.
I will have several comboboxes using this list (if possible) and some may be left blank.
If someone could make a working example I would really appreciate it. I am just learning to use excel.
Thanks
I have a combo box on Sheet 2 to reference the Names in the list Activity.
I want to be able to type in the combox the first letter of the name and it narrows down the choices. Then when I type in the second letter of the name it narrows the choices even more. The more of the name I tye the less choices I have.
I will have several comboboxes using this list (if possible) and some may be left blank.
If someone could make a working example I would really appreciate it. I am just learning to use excel.
Thanks