Data Validation Problems/Questions

[Rich9016]

Hi everyone,
I'm having some issues and I have some questions for data validation.


First, I can't seem to get my warnings to work. They initially worked
but all of a sudden it stopped and i can type whatever I want.
didn't change anything, just added a bunch or rows full of information
below the selected cells. Any idea what's going on?

Second, I have three cells, B3, B4 and B5. I want it so that one mus
enter info first in B3, then in B4 and then in B5, in subsequent order
Also, if I delete B3, I want B4 and B5 to automatically clear as well
Help??

Lastly, is there any way for a worksheet to unhide based on
validation choice?

As usual, any help would be appreciated. Thanks in advance!

Ric

 

[Frank Kabel]

Hi
your second and third request are not possible without VBA
Do you want to go this way?. If yes please post back for a VBA solution
(using worksheet_change events for example)

 

[AlfD]

Hi!

Have you checked that the validation statements are still there?
Have you tried re-applying them? What happens?

Al

 

[Rich9016]

Thanks for responding guys.

Frank, I'm not really good with VBA so I'm a little concerned wit
doing anything that involves it. However, if that's what it'll take
then I'll do it!!

AlfD, I removed the validation and then reapplied it, but still n
warning pops up. However, when i start a new sheet, it works. Bu
here's the kicker, after I add all my rows (7-125) it doesn't wor
again! Is there a limit to the info in a sheet or some bug like that

 

[Frank Kabel]

Hi
if you like email me your file (with description of the desired
validation rules!) and I'll insert some code for you into it
Also include the error you described

email: frank[dot]kabel[at]freenet[dot]de