Hi, I wanted to get the value from the dropdown in the excel file
I tried using select item however unable to get element region.
What activity can I use to solve the issue.
Regards,
Ainaa
Select item is used to select but not to get…
And also in excel dropdown…may I knoe the use case so that we may suggest alternative approaches if any
This is one way to get the values…here it is written to B column…we can send the full as a return value as well…
Cheers
Hi thanks for the reply,
The use case im doing right now is to select a “date range” that contains “today’s date”
Let say today is 10/10/2023, it will select the dropdown value range of date from “6 oct 2023 to 12 oct 2023”
Do you know becore hand what values might be present?
If yes…then based on the input value choose the value to select and use write cell to populate the value as required
If not use the above vba to get the date ranges…then check in which range the given date falla and then use write cell to write the data
Cheers
The process will get the date range that contains todays’s date.
it means i need to hardcode the date range?
You need not hardcode …you can have all the values in an array and pick the value which matches with given date
cheers
do u have example for this?
thanks
- Use the above method given to get values frok dropdown
- Once you get it say it is stored in list…you can use a loop and pass the list as input and inside loop use if condition to check if the date is between the dates …
Cdate(currentItem.Split({"to"},Stringsplitoptions.None)(0).Trim) < Now And Cdate(currentItem.Split({"to"},Stringsplitoptions.None)(1).Trim) > Now
On then side you get the matched value
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.