Dropdown selection in Excel sheet

Help
1

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!

2

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

2 Likes
3

Hi,

Please take a look at this one. it has the solution to select the dropdown list.

Regards
Balamurugan.S

4

Hi, probably it solves the issue, but this package requires a paid license. Are there any other options, without UIAutomation?

5

Hi @balupad14 - this package need paid license are there any other options ?

6

Hi Guys @Sudharsan_Ka @Gokul001 @Yoichi

Is there is any way to do this in background?

or we need to do this only in the foreground?

Thanks,
Shreyash

7

Hi @mukeshkala,

Is there any way where we can do this in background?

Thanks,
Shreyash

8

You can try recording a macro for the same and execute it