You would have to create a userform with a combobox on it to do this, the Inputbox method does not have a dropdown.