certain mandatory cells

[john_cash]

Hi everyone,
how to make only yellow cells mandatory?
The writing is horizontal, if I write in C3 and B3 is empty, a warning must appear etc ...
john

[mehmetcik]

Sorry John

Your requirement is not clear. In your example B3 is not yellow so why would you expect a message?

Right Click on your sheet name at the bottom of excel and select view code.

Paste this code into the module that opens and close the module.

Please Login or Register  to view this content.

If you now select any yellow cell. You will get an alert if the cell to the left is empty.

This will get you started.

[Pepe Le Mokko]

B3 is yellow for me? ( I suppose you meant C3 ?)
@ john
what are the rules to determine that B3 should be used before C4 ? What about E3 ?

[john_cash]

Hi mehmetcik work almost good.
if I click in column A it gives an error

error defined by application or object

[john_cash]

if B3 is not compiled it is not written in all other cells
if E3 is not compiled it is not written in all other cells
if C4 is not compiled it is not written in all other cells
if H4 is not compiled it is not written in all other cells

etc.....

[mehmetcik]

Ahh column A will always give an error because we are checking the cell to the left.

Try this code instead.

Please Login or Register  to view this content.

[john_cash]

Hi mehmetcik work almost good.
Not work in column A
another mistake:
if I select a non-empty yellow cell, a warning appears

[mehmetcik]

Please Login or Register  to view this content.

[john_cash]

Hi mehmetcik

if I select a non-empty yellow cell, a warning appears <<< ok correct

Not work in column A

[mehmetcik]

It cannot work in column A. There is no Cell to the left of Column A so there is nothing that must be filled.

Please Login or Register  to view this content.

[john_cash]

Hi mehmetcik,
i inserted a support column A now works better.
Thank you very much
john

[john_cash]

Hi

Please Login or Register  to view this content.

is a change possible?
Now if I move with the tab closing the warning I can continue with the following cells.
Is this possible?:
until the first cell is filled in, you cannot continue and so on for the second, third etc ...

[mehmetcik]

Please Login or Register  to view this content.

[john_cash]

Hi mehmetcik it's ok.
it is possible instead of the yellow cells either

Please Login or Register  to view this content.

is referenced to cells but does not work

Please Login or Register  to view this content.