I frequently have to look up certain events and read what returning true and false means.<\/p>\n\n\n\n
I dont try to memorize this stuff any more.<\/p>\n\n\n\n
One thing I do is insert something like<\/p>\n\n\n\n
\/\/ this makes things semantically easier to deal with \n\/\/ and easier to read\nConst rejectKey = True\nConst acceptKey = False<\/code><\/pre>\n\n\n\ninto keydown handlers and then return rejectKey and acceptKey from whatever code I write. My code then reads like<\/p>\n\n\n\n
\/\/ number ?\nIf Asc(key) >= Asc(\"0\") And Asc(key) <= Asc(\"9\") Then\n Return acceptKey\nEnd If\n\/\/ permits negative numbers being entered\nIf currentCellContents = \"\" And key = \"-\" Then\n Return acceptKey\nEnd If<\/code><\/pre>\n\n\n\nand its a lot clearer what the intention is<\/p>\n","protected":false},"excerpt":{"rendered":"
I frequently have to look up certain events and read what returning true and false means. I dont try to memorize this stuff any more. One thing I do is insert something like into keydown handlers and then return rejectKey and acceptKey from whatever code I write. My code then reads like and its a … <\/p>\n