Msgbox when trying to fill in cells before another cell is filled out

[Abekaj]

Hi

I am new into vba and I have got stuck with a code I can't find a solution for.

What I want, is a message box to appear if the user tries to fill in values in a specific range of empty cells, before filling out one specific cell on another sheet first.

So what the code needs to do, is to check if one cell on another sheet is empty, before you are allowed to fill in data in a range of other cells. If the cell is empty, a message box should appear as soon as the user clicks on one of the cells in the range.

I am guessing that I should be using IsEmpty somehow, but I cannot figure out how to activate it just by selecting one of the cells in the range?


Hope someone can help me with this

[cubangt]

You will probably want to have the code within the "Worksheet Change Event"
There is a way to do it check the range
You can take a look here:

https://stackoverflow.com/questions/...range-is-empty

Example:

Please Login or Register  to view this content.

within the Empty line above, you can add your statement to present the user, and if its not empty, meaning everything is filled in, then you can just skip that condition and remove it like this:

Please Login or Register  to view this content.