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!

You can make use of Hotkeys :slight_smile:

For Excel - If we have a DropDown - Assuming the DropDown is in Cell A4.

Below would be the Automation steps.

  1. Send Hotkey : Ctrl G - This will open the Goto Cell menu
  2. type Into Goto : A4 and Hit Enter - To highlight the Cell having Formula
  3. Send Hotkey : Alt + DownArrow - This os Open the DropDown.
  4. Make use of Ui Automation of More hotkeys as required.

Before attempting the above - would request you to Do the Steps manually . If you are able to open Dropdown without using Mouse - Mimic same steps with send Hotkeys.


Mukesh