showing drop down list when combo box is activated

i have a combo box control placed on the sheet. i want that when combobox is activated, it should automatically open the drop down list. so is there any code. please help me out.

Originally Posted by Carim

Hi,

Go to Data Validation and select in-cell dropdown ...

BUT IT IS CONTROL OBJECT COMBOBOX & NOT CELL.

REGARDS