Select item from Combo box in Excel

[meghna.b.das]

Hello,

My workbook has a combo box. I need to be able to select options from the drop down/combo box. I tried using ‘Click’ and then ‘Select Item’ activities in order to do this. However, they are not very reliable selectors. Please suggest a work-around for this.

[monsieurrahul (Rahul)]

@meghna.b.das, check this:

Dropdown selection in Excel sheet

Hi, I want to write in an excel which contain some dropdown cells in a row. I need to show the values of these dropdown to user in an input box, and then based on selected value from user, write them in excel. Can anyone please let me know how to achieve this. Thanks!