Watch this 5 min video:
How to setup a data validation drop down list:
http://youtube.com/watch?v=t2OsWJijrOM
--
Biff
Microsoft Excel MVP
"Link" wrote in message
...
What is vba?
"Shane Devenshire" wrote:
Hi,
No formula but you can use vba in which case I would double-click to
toggle
thru all three possibilities - Y, N, and blank. Will that work for you?
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Link" wrote:
Is there a formula to use if you want the answer Y or N in cells
without
having to type it all the time for (example formatting the column so
that if
I click the mouse twice Y comes up if I click once N comes up.