Can we use a Radio button or any button from the Developer Tab to open up the data validation drop-down list in a cell?
I am using XLOOKUP in cell E2 and the Lookup value is cell A3. Now, this cell A3 is the cell where I have my Data Validation Drop-down list. My problem is the Data Validation drop-down icon will disappear when clicking on some other cell. So I am wondering if I can create a Radio Button from Developer Tab and place it near cell A3 so that it will be easy to identify that there is a click-to-action button to open up the cell A3.
I am using XLOOKUP in cell E2 and the Lookup value is cell A3. Now, this cell A3 is the cell where I have my Data Validation Drop-down list. My problem is the Data Validation drop-down icon will disappear when clicking on some other cell. So I am wondering if I can create a Radio Button from Developer Tab and place it near cell A3 so that it will be easy to identify that there is a click-to-action button to open up the cell A3.