Hi,
Anybody could help me how to select item from dropdown in excel sheet.
aquinn
(Aquinn)
December 20, 2022, 11:48am
2
Can you provide a screenshot of the excel sheet and your expected outcome
aquinn
(Aquinn)
December 20, 2022, 11:51am
4
You may be able to use click image on the drop down lcon or you could use an activity called select item to get the element and options of the drop down
Hi ,
The below post can be used for the selection of data from dropdown in Excel.
You can make use of Hotkeys
For Excel - If we have a DropDown - Assuming the DropDown is in Cell A4.
Below would be the Automation steps.
Send Hotkey : Ctrl G - This will open the Goto Cell menu
type Into Goto : A4 and Hit Enter - To highlight the Cell having Formula
Send Hotkey : Alt + DownArrow - This os Open the DropDown.
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 ope…
the bot should select one and data’s will change accordingly in other cells.
system
(system)
Closed
December 23, 2022, 11:53am
7
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.