Hello to everyone. I hope I can find help here again with my Excel issue.
The scenario is the following: I have an array of five cells where whole numbers greater than zero will be input by the user. When the user inputs data into any single one of those array cells, they will then be restricted from entering any data into the remaining four cells of the same array. The array is static, not dynamic. The user must be able to enter data into any single one of the array cells in any order within the array and be restricted from entering data into any of the other four cells.
How do I make this happen??? I would prefer to use Excel formulas within the workbook; however, I am open to VB code to do so.
Any help is greatly appreciated.
Thanks,
DAK
The scenario is the following: I have an array of five cells where whole numbers greater than zero will be input by the user. When the user inputs data into any single one of those array cells, they will then be restricted from entering any data into the remaining four cells of the same array. The array is static, not dynamic. The user must be able to enter data into any single one of the array cells in any order within the array and be restricted from entering data into any of the other four cells.
How do I make this happen??? I would prefer to use Excel formulas within the workbook; however, I am open to VB code to do so.
Any help is greatly appreciated.
Thanks,
DAK
