How to require a cell input if another cell has a value

Posted by Connor on Super User See other posts from Super User or by Connor
Published on 2014-06-02T15:26:02Z Indexed on 2014/06/02 15:32 UTC
Read the original article Hit count: 291

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I can get excel to check a cell for any input and require it have input, but I need it to check if a different cell has an input before requiring input. This is because not all of the lines in my spreadsheet will be used all of the time, but some people forget to put very important pieces of information in the spreadsheet which throws some of our balances off.

An SKU is entered on the sheet when we switch to a new one, and I want the program to make sure there is an amount of product in a given cell every time a new SKU is entered onto the sheet.

Thanks.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about worksheet-function