For example, if your list of combo box options is located between cells E2 and E10 or your worksheet, you would enter "E2:E10" into the Input Range box. Advertisement Article continues below this ad ...