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: 318
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