Data Validation
 

I have read through MANY of the posts on here and haven't seemed to find an
answer(and if I overlooked it, sorry!)
I am trying to put data validation on a "description" cell. I would like a
validation box to pop up if the user skips the description box and fills out
the information below it. Can this be done? I have tried ISBLANK, and a few
"" formulas and am having NO luck.
Thanks in advance :)

Data Validation
 

You don't put the validation on the "description cell" itself, you put it on
the cells below it that you don't want to allow an entry in if the
"description cell" is blank. For example, if B3 is the address of your
"description cell", then select the cells below it, starting with B4 (so
that B4 remains the active cell) and put this Custom formula in the
Data/Validation for that selection...

=LEN(OFFSET(B$4,-1,0))0

Just make sure you replace my example B$4 address with the address (absolute
row) for the active cell in your selection.

Rick


"frustratedwthis" wrote in
message ...
I have read through MANY of the posts on here and haven't seemed to find an
answer(and if I overlooked it, sorry!)
I am trying to put data validation on a "description" cell. I would like
a
validation box to pop up if the user skips the description box and fills
out
the information below it. Can this be done? I have tried ISBLANK, and a
few
"" formulas and am having NO luck.
Thanks in advance :)

Data Validation
 

I tried that, however, it gives me the validation error even if there is text
in the cell. Another thing that might be causing the problem is, the cells
are merged. (A12:I13)
I put the validation code in cells A17:20. I am not sure what it is I am
doing wrong
:(
Thanks


"Rick Rothstein (MVP - VB)" wrote:

You don't put the validation on the "description cell" itself, you put it on
the cells below it that you don't want to allow an entry in if the
"description cell" is blank. For example, if B3 is the address of your
"description cell", then select the cells below it, starting with B4 (so
that B4 remains the active cell) and put this Custom formula in the
Data/Validation for that selection...

=LEN(OFFSET(B$4,-1,0))0

Just make sure you replace my example B$4 address with the address (absolute
row) for the active cell in your selection.

Rick


"frustratedwthis" wrote in
message ...
I have read through MANY of the posts on here and haven't seemed to find an
answer(and if I overlooked it, sorry!)
I am trying to put data validation on a "description" cell. I would like
a
validation box to pop up if the user skips the description box and fills
out
the information below it. Can this be done? I have tried ISBLANK, and a
few
"" formulas and am having NO luck.
Thanks in advance :)

Data Validation
 

Merged cells? Bingo! I don't work with merged cells myself, but the word is
they are the cause of untold problems. Since the formula I posted works for
me using no merged cells, and not for you with your merged cells, I'd have
to say that is what is causing the formula not to work.

Rick


"frustratedwthis" wrote in
message ...
I tried that, however, it gives me the validation error even if there is
text
in the cell. Another thing that might be causing the problem is, the
cells
are merged. (A12:I13)
I put the validation code in cells A17:20. I am not sure what it is I am
doing wrong
:(
Thanks


"Rick Rothstein (MVP - VB)" wrote:

You don't put the validation on the "description cell" itself, you put it
on
the cells below it that you don't want to allow an entry in if the
"description cell" is blank. For example, if B3 is the address of your
"description cell", then select the cells below it, starting with B4 (so
that B4 remains the active cell) and put this Custom formula in the
Data/Validation for that selection...

=LEN(OFFSET(B$4,-1,0))0

Just make sure you replace my example B$4 address with the address
(absolute
row) for the active cell in your selection.

Rick


"frustratedwthis" wrote in
message ...
I have read through MANY of the posts on here and haven't seemed to find
an
answer(and if I overlooked it, sorry!)
I am trying to put data validation on a "description" cell. I would
like
a
validation box to pop up if the user skips the description box and
fills
out
the information below it. Can this be done? I have tried ISBLANK, and
a
few
"" formulas and am having NO luck.
Thanks in advance :)

Data Validation
 

I unmerged my cells and still a no go. I have no idea what I am doing wrong.
Thank you for all your help!

"Rick Rothstein (MVP - VB)" wrote:

Merged cells? Bingo! I don't work with merged cells myself, but the word is
they are the cause of untold problems. Since the formula I posted works for
me using no merged cells, and not for you with your merged cells, I'd have
to say that is what is causing the formula not to work.

Rick


"frustratedwthis" wrote in
message ...
I tried that, however, it gives me the validation error even if there is
text
in the cell. Another thing that might be causing the problem is, the
cells
are merged. (A12:I13)
I put the validation code in cells A17:20. I am not sure what it is I am
doing wrong
:(
Thanks


"Rick Rothstein (MVP - VB)" wrote:

You don't put the validation on the "description cell" itself, you put it
on
the cells below it that you don't want to allow an entry in if the
"description cell" is blank. For example, if B3 is the address of your
"description cell", then select the cells below it, starting with B4 (so
that B4 remains the active cell) and put this Custom formula in the
Data/Validation for that selection...

=LEN(OFFSET(B$4,-1,0))0

Just make sure you replace my example B$4 address with the address
(absolute
row) for the active cell in your selection.

Rick


"frustratedwthis" wrote in
message ...
I have read through MANY of the posts on here and haven't seemed to find
an
answer(and if I overlooked it, sorry!)
I am trying to put data validation on a "description" cell. I would
like
a
validation box to pop up if the user skips the description box and
fills
out
the information below it. Can this be done? I have tried ISBLANK, and
a
few
"" formulas and am having NO luck.
Thanks in advance :)

Data Validation
 

I'm not sure what cells you had merged together nor what cells are now in
use after you unmerged them. What is your layout now; that is, where is your
"description cell" located? Also, if you set up the formula while your cells
were merged, I'm guess it got screwed up when you unmerged the cells, so you
may have to re-select the range of cells you want to have the validation and
re-apply the validation formula.

Rick


"frustratedwthis" wrote in
message ...
I unmerged my cells and still a no go. I have no idea what I am doing
wrong.
Thank you for all your help!

"Rick Rothstein (MVP - VB)" wrote:

Merged cells? Bingo! I don't work with merged cells myself, but the word
is
they are the cause of untold problems. Since the formula I posted works
for
me using no merged cells, and not for you with your merged cells, I'd
have
to say that is what is causing the formula not to work.

Rick


"frustratedwthis" wrote in
message ...
I tried that, however, it gives me the validation error even if there is
text
in the cell. Another thing that might be causing the problem is, the
cells
are merged. (A12:I13)
I put the validation code in cells A17:20. I am not sure what it is I
am
doing wrong
:(
Thanks


"Rick Rothstein (MVP - VB)" wrote:

You don't put the validation on the "description cell" itself, you put
it
on
the cells below it that you don't want to allow an entry in if the
"description cell" is blank. For example, if B3 is the address of your
"description cell", then select the cells below it, starting with B4
(so
that B4 remains the active cell) and put this Custom formula in the
Data/Validation for that selection...

=LEN(OFFSET(B$4,-1,0))0

Just make sure you replace my example B$4 address with the address
(absolute
row) for the active cell in your selection.

Rick


"frustratedwthis" wrote in
message ...
I have read through MANY of the posts on here and haven't seemed to
find
an
answer(and if I overlooked it, sorry!)
I am trying to put data validation on a "description" cell. I would
like
a
validation box to pop up if the user skips the description box and
fills
out
the information below it. Can this be done? I have tried ISBLANK,
and
a
few
"" formulas and am having NO luck.
Thanks in advance :)

Data Validation
 

Cells A12:I13 are merged so that the user can key in a description using text
and #'s if necessary. Without the cells being merged, the description would
be in A12.
I am putting the data validation formula in cells A17:A20. In these cells,
you put an "X" to choose a corresponding goal. I would like to set it up
where they can't choose a corresponding goal without a description.
Again, thank you for your help :)

"Rick Rothstein (MVP - VB)" wrote:

I'm not sure what cells you had merged together nor what cells are now in
use after you unmerged them. What is your layout now; that is, where is your
"description cell" located? Also, if you set up the formula while your cells
were merged, I'm guess it got screwed up when you unmerged the cells, so you
may have to re-select the range of cells you want to have the validation and
re-apply the validation formula.

Rick


"frustratedwthis" wrote in
message ...
I unmerged my cells and still a no go. I have no idea what I am doing
wrong.
Thank you for all your help!

"Rick Rothstein (MVP - VB)" wrote:

Merged cells? Bingo! I don't work with merged cells myself, but the word
is
they are the cause of untold problems. Since the formula I posted works
for
me using no merged cells, and not for you with your merged cells, I'd
have
to say that is what is causing the formula not to work.

Rick


"frustratedwthis" wrote in
message ...
I tried that, however, it gives me the validation error even if there is
text
in the cell. Another thing that might be causing the problem is, the
cells
are merged. (A12:I13)
I put the validation code in cells A17:20. I am not sure what it is I
am
doing wrong
:(
Thanks


"Rick Rothstein (MVP - VB)" wrote:

You don't put the validation on the "description cell" itself, you put
it
on
the cells below it that you don't want to allow an entry in if the
"description cell" is blank. For example, if B3 is the address of your
"description cell", then select the cells below it, starting with B4
(so
that B4 remains the active cell) and put this Custom formula in the
Data/Validation for that selection...

=LEN(OFFSET(B$4,-1,0))0

Just make sure you replace my example B$4 address with the address
(absolute
row) for the active cell in your selection.

Rick


"frustratedwthis" wrote in
message ...
I have read through MANY of the posts on here and haven't seemed to
find
an
answer(and if I overlooked it, sorry!)
I am trying to put data validation on a "description" cell. I would
like
a
validation box to pop up if the user skips the description box and
fills
out
the information below it. Can this be done? I have tried ISBLANK,
and
a
few
"" formulas and am having NO luck.
Thanks in advance :)