Alerting for incorrect cell values

Posted by Allan on Stack Overflow See other posts from Stack Overflow or by Allan
Published on 2010-03-26T05:03:55Z Indexed on 2010/03/26 5:13 UTC
Read the original article Hit count: 346

Filed under:

user-input

|

macros

|

excel-vba

|

named-ranges

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

© Stack Overflow or respective owner

Related posts about user-input

Call methods in main method

as seen on Stack Overflow - Search for 'Stack Overflow'
this is my main method that gets 3 integers from command line and I parse then in my validating method. However I have one operation method that calls 3 other methods, but i don't know what type of data and howmany I have to put in my operatinMethod() " cuase switch only gets one); AND also in my… >>> More
QTableWidget signal cellChanged(): distinguish between user input and change by routines

as seen on Stack Overflow - Search for 'Stack Overflow'
i am using PyQt but my question is a general Qt one: I have a QTableWidget that is set up by the function updateTable. It writes the data from DATASET to the table when it is called. Unfortunately this causes my QTableWidget to emit the signal cellChanged() for every cell. The signal cellChanged()… >>> More
Script stops while waiting for user input from STDIN.gets

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to do something like this, where I have two loops going in seperate threads. The problem I am having is that in the main thread, when I use gets and the script is waiting for user input, the other thread is stopped to wait as well. class Server def initialize() @server = TCPServer… >>> More
Printing Stdout In Command Line App Without Overwriting Pending User Input

as seen on Stack Overflow - Search for 'Stack Overflow'
In a basic Unix-shell app, how would you print to stdout without disturbing any pending user input. e.g. Below is a simple Python app that echos user input. A thread running in the background prints a counter every 1 second. import threading, time class MyThread( threading.Thread ): running… >>> More
QTableWidget signal cellChanged(): distinguish between user input and chage by routines

as seen on Stack Overflow - Search for 'Stack Overflow'
i am using PyQt but my question is a general Qt one: I have a QTableWidget that is set up by the function updateTable. It writes the data from DATASET to the table when it is called. Unfortunately this causes my QTableWidget to emit the signal cellChanged() for every cell. The signal cellChanged()… >>> More

Related posts about macros

"macros have been disabled" message in Word 2007 but no macros

as seen on Super User - Search for 'Super User'
Hi there, I open a .doc file in Word 2007 (sorry I am unable to supply the .doc) which pops up with a message above the document "Security warning: Macros have been disabled" but there are no macros shown in the macros listing and no functionality displayed in the VBScript editor. Why does Word… >>> More
Avoiding symbol capture when using macros to generate functions (or other macros)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm a bit confused as to exactly when symbol capture will occur with clojure macros. Suppose that I have a macro which defines a function from keywords. In this trivial example, (defmacro foo [keywd1 keywd2] `(defn ~(symbol (name keywd1)) [~(symbol (name keywd2))] (* 2 ~(symbol… >>> More
Macros's that define macros

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know how to pull off something like this... I have alot of repetitive macros as : - #define MYMACRO1(x) Do1(x) #define MYMACRO2(x,y) Do2(x, y) #define MYNEXTMACRO1(x) Do1(x) #define MYNEXTMACRO2(x,y) Do2(x, y) The code above works fine, but I want to write a macro… >>> More
Macros in macros (C++)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to put a macro in a macro in c++? Something like: #define Something\ #ifdef SomethingElse\ //do stuff \ #endif\ I tried and it didn't work so my guess is it doesn't work, unless there's some sort of syntax that can fix it? >>> More
makefile: how to call macros in macros

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have the following macros in my make file: pdf: // do something clean: // just another fancy thing No I want to declare a macro all: which include (or call) the makros above. The following thing doesn't work: all: pdf: clean: I don't want to repeat the code from pdf:… >>> More