Hi, I'm loking for some advice how to best do following:
I'm having a spreadsheet with a cell layout, that corresponds my needs. Now I would like to add certain behavoir as beeing known from web forms to a few cells. - having a select box instead of free entry for certain cells - triggering en event (macro) when the contents of one of these cells changed Rephrased: 1. Limited input range for cells ------------------------------------ When clicking (or doubleclicking) on the cell I would get a select box or a minidialoge offering me the possible options. Examples: - numbers only from 1 to 12 - or text, but only 'Yes' and 'No' 2.) Sanity check of certain cell inputs ------------------------------------------- - after having changed the value of a cell. - I'd like to trigger a macro, which performs some sanity checks. Thanks for any suggestions or ideas how you attack similiar problems. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
