One of my pet peeves is intrusive VBA code that interrupts workflow. The problem usually goes something like this:

I have an application/workbook that relies on certain user input data. I have a textbox/cell and I only want certain characters to be allowed. (list of characters follows) How can I accomplish this?

The answer usually involves some version of Worksheet_Change or KeyPress events that detect the input characters and act accordingly.

Continue Reading: Restricting character input in a textbox on a userform »