I can't seem to do this in one fell swoop. I can create a check on the
forms toolbar and paste it into a cell. But the cell is too small and
I'd rather not increase the size of the cell. I'd also like a check
mark in every cell that runs down a column, about 50 or so. Is there a
wat to automatically do this, as well?

Hi,

Creating a check means flagging the cells. So you might need VBA for
this. If you need flagging the cell without VBA you may use Y or N for
the cells. Try this one.


thanks

Shail


nickravo wrote:

I can't seem to do this in one fell swoop. I can create a check on the
forms toolbar and paste it into a cell. But the cell is too small and
I'd rather not increase the size of the cell. I'd also like a check
mark in every cell that runs down a column, about 50 or so. Is there a
wat to automatically do this, as well?

You lost me. Flagging?

shail wrote:
Hi,

Creating a check means flagging the cells. So you might need VBA for
this. If you need flagging the cell without VBA you may use Y or N for
the cells. Try this one.


thanks

Shail


nickravo wrote:

I can't seem to do this in one fell swoop. I can create a check on the
forms toolbar and paste it into a cell. But the cell is too small and
I'd rather not increase the size of the cell. I'd also like a check
mark in every cell that runs down a column, about 50 or so. Is there a
wat to automatically do this, as well?

Hi Nikravo,

It is unclear what you need to do by a check. With the check you will
either say ckecked or not (isn't it) or simply "YES" and "NO".

Suppose you have your data from A1 to A10, Then make a drop down
validation list on B1 saying Yes or No. Make it from Menu - Data /
Validation. Click on "Allow", select "List". Type: Yes, No in box given
below. Click Ok. Copy and Paste it till B10.

Now on the C1 till C10 you can have the function as
=if(B1="YES",...,if(B1="NO",...,"")

For "....", I mean what you want to do if YES is selected or what if NO
is selected.

I hope this works for you.


Thanks

Shail

nickravo wrote:
You lost me. Flagging?

shail wrote:
Hi,

Creating a check means flagging the cells. So you might need VBA for
this. If you need flagging the cell without VBA you may use Y or N for
the cells. Try this one.


thanks

Shail


nickravo wrote:

I can't seem to do this in one fell swoop. I can create a check on the
forms toolbar and paste it into a cell. But the cell is too small and
I'd rather not increase the size of the cell. I'd also like a check
mark in every cell that runs down a column, about 50 or so. Is there a
wat to automatically do this, as well?

Sorry to be so dense, but I haven't a clue what a valadation list is.
Let's say from A1 to A10 I want to put a check mark (yes is a check; no
is empty). What do I do?


shail wrote:
Hi Nikravo,

It is unclear what you need to do by a check. With the check you will
either say ckecked or not (isn't it) or simply "YES" and "NO".

Suppose you have your data from A1 to A10, Then make a drop down
validation list on B1 saying Yes or No. Make it from Menu - Data /
Validation. Click on "Allow", select "List". Type: Yes, No in box given
below. Click Ok. Copy and Paste it till B10.

Now on the C1 till C10 you can have the function as
=if(B1="YES",...,if(B1="NO",...,"")

For "....", I mean what you want to do if YES is selected or what if NO
is selected.

I hope this works for you.


Thanks

Shail

nickravo wrote:
You lost me. Flagging?

shail wrote:
Hi,

Creating a check means flagging the cells. So you might need VBA for
this. If you need flagging the cell without VBA you may use Y or N for
the cells. Try this one.


thanks

Shail


nickravo wrote:

I can't seem to do this in one fell swoop. I can create a check on the
forms toolbar and paste it into a cell. But the cell is too small and
I'd rather not increase the size of the cell. I'd also like a check
mark in every cell that runs down a column, about 50 or so. Is there a
wat to automatically do this, as well?

Hi again Nickravo,

The use of check mark is much more tough than the use of Validation
List, because it uses VBA codes.

Just try what I told you before. Once you made it, you will feel it is
so easy to use.


Good luck

Shail


nickravo wrote:
Sorry to be so dense, but I haven't a clue what a valadation list is.
Let's say from A1 to A10 I want to put a check mark (yes is a check; no
is empty). What do I do?

And what is a validation list?

shail wrote:
Hi again Nickravo,

The use of check mark is much more tough than the use of Validation
List, because it uses VBA codes.

Just try what I told you before. Once you made it, you will feel it is
so easy to use.


Good luck

Shail


nickravo wrote:
Sorry to be so dense, but I haven't a clue what a valadation list is.
Let's say from A1 to A10 I want to put a check mark (yes is a check; no
is empty). What do I do?

See this:

http://contextures.com/xlDataVal01.html

Biff

"nickravo" wrote in message
ups.com...
And what is a validation list?

shail wrote:
Hi again Nickravo,

The use of check mark is much more tough than the use of Validation
List, because it uses VBA codes.

Just try what I told you before. Once you made it, you will feel it is
so easy to use.


Good luck

Shail


nickravo wrote:
Sorry to be so dense, but I haven't a clue what a valadation list is.
Let's say from A1 to A10 I want to put a check mark (yes is a check; no
is empty). What do I do?