Alerting for incorrect cell values

My problem: I have two ranges R16 and R01. These ranges were set up by swiping each range and then renaming them in the upper left panel of the sheet. Each range requires users to fill in each cell with a value. R16 requires users to enter a number of 0 through 5. The range R01 requires a value of 0 or 1 to be entered. NO cell can be left blank in any cell within these two ranges. These ranges and requirements are specific to this sheet only. It would be nice if at the time of user entering a number, an error message appeared like [invalid entry] if the value inputted was outside parameters set. For example, in R16, if someone entered 12 or -1 they would be alerted. Finally when the user presses a button on the page to use these values in a separate process, it is essential to check that no cell is left blank. I am trying to find a way to halt the running of the marco (via the button) if these parameters above are not met. Thank you

Answers


You don't need programming for the first part, this is a built-in feature in Excel called "Validation". The second part of your question, the pressing of the button, requires a macro that checks both cells.


Need Your Help

Typescript for Facebook React

reactjs typescript react-jsx

I've been looking into React lately and was hoping to use JSX and typescript. I haven't been able to find any resources on this or type definitions for React.

Modify a ListBox's item from a button in it's template?

c# wpf silverlight data-binding xaml

In my Silverlight 3 project, I'm using a ListBox to display results of a Get() operation form a WCF WebService.