frustratedwthis
6/19/2008 6:48:00 PM
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" <frustratedwthis@discussions.microsoft.com> wrote in
> message news:B8100280-F78B-4D97-82EA-F69752B897E0@microsoft.com...
> >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" <frustratedwthis@discussions.microsoft.com> wrote in
> >> message news:6BAE911A-2564-4491-92B5-2FBD4AF78A55@microsoft.com...
> >> >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" <frustratedwthis@discussions.microsoft.com> wrote in
> >> >> message news:AC4FF9AF-B0FF-4486-A6D1-5CB71DA93910@microsoft.com...
> >> >> >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 :)
> >> >> >
> >> >>
> >> >>
> >>
> >>
>
>