[Link[_2_]]

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.

[Shane Devenshire[_2_]]

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.

[RagDyeR]

Since it seems that you want to stay away from the keyboard, why not create
a "Data Validation" drop down list, where there are only those two (Y - N )
choices?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Link" wrote in message
...
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.

[Link[_2_]]

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.

[T. Valko]

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.