Hi all,
I have a workbook that is set by an outside company with a number of validation drop down lists within it.
The lists seem to dynamically filter to a set answer depending on what is put in the first cell in the column.
Despite this there is still a need to click on each data validation list and select the only entry within it. (due to the filtering)
I cannot do anything to change the way the workbook is set up but am trying to write a macro to auto select the entry from the drop down.
I can get the drop down to open using
but m struggling to get the code to then select the only item within the dropdown.
any advice or pointers please.
I have a workbook that is set by an outside company with a number of validation drop down lists within it.
The lists seem to dynamically filter to a set answer depending on what is put in the first cell in the column.
Despite this there is still a need to click on each data validation list and select the only entry within it. (due to the filtering)
I cannot do anything to change the way the workbook is set up but am trying to write a macro to auto select the entry from the drop down.
I can get the drop down to open using
VBA Code:
Application.SendKeys ("%{down}")any advice or pointers please.
