check cells

[mdshotgun]

Hello,

In my worksheet i need to check cells to make sure they have data before the next range can accept data.

Example.

I want to make sure range N4:Q11 has data in each cell before range P15:Q18 can accept data.

If range N4:Q11 has all data and P15:Q18 starts accepting data and if someone decides to clear any data from first range
i would like excel to stop them.

I would appreciate any help with this.

Thanks.

[Fotis1991]

Hi

You can use a custom validation to range P15:Q18 for not allowing the users to use this range unless if the other range is full of data using this formula in custom validation bar

Please Login or Register  to view this content.

but you can not force the users to don't delete data without to use VBA.

edit: because as i understand you need to allow them to type anuthing in first range but you don't want to allow them to delete data in that range.

[mdshotgun]

Hello Fotis1991,

Thanks for your reply.

The data in file is sensitive,so i have mocked up a dummy sheet example.

I have attempted to write some code myself but i am no programmer
but it will give me the msgbox when there is a cell empty in the range
but it seems to go into an infinite loop.

I would think my code is a mile off what is needed.

[Fotis1991]

This looks to work.

Please Login or Register  to view this content.

[mdshotgun]

Thanks again for the reply and the help.

Because i commented out the Exit Sub it made it go into an infinite loop.

[Fotis1991]

Exactly!!

You are welcome and thanks for the feedback.