I have an excel-sheet with a drop-down-menu with various values. (for example “A,”,B" and "C).
Is there a way to change the value of the drop down? (for example from “A” to “C”? ) with Applescript?
Thank you for your answer.
Of course here are 2 screenshots, of the Excel-Sheet with the DropDown. The values are defined in “Date validation”. My question is, is there a way to change the value-selection in this drop down.
Example; I would like to change the Value from “Value1” to “Value3”.
You can just set the value of such a cell to one of the values from the dropdown list, and the list will remain intact.
I’m assuming setting a value not in the list will destroy the validation - I never tested that.
tell application "Microsoft Excel"
set value of column x of row y to "some_list_value_here"
-- or any other cell reference that you prefer
end tell