Forum Discussion
Yes No in a cell with yes shown unless changed to no
How do i create a cell with yes displayed with a dropdown to display No if required
NikolinoDE Thanks for the help, do you know how would i keep the yes reply displayed and only change to no if required
As far as I know, you cannot enter text and a formula in the same cell at the same time.
Can probably only be done via VBA.
If you can use VBA, please send the following information.
Excel version, operating system name and version, an Excel file (without sensitive data),
so as far as possible you can get a suggested solution that suits your needs.
For the next time, with your permission, I recommend that you follow this advice.
Click on the link for detailed information.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)