Putting check marks in every cell in a column?
 

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?

Putting check marks in every cell in a column?
 

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?

Putting check marks in every cell in a column?
 

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?

Putting check marks in every cell in a column?
 

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?

Putting check marks in every cell in a column?
 

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?

Putting check marks in every cell in a column?
 

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?

Putting check marks in every cell in a column?
 

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?

Putting check marks in every cell in a column?
 

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?