I have a UserForm with a TextBox on it that allows the user to input up to 1,000 characters of notes. There are certain characters that are not allowed such as slashes, parens, ampersands, etc. I have a function that keeps these characters out (using the KeyPressed event) but, I would like to be able to detect when the user has used "paste" to populate the TextBox. The Keypressed event only fires when the user types the information in manually.

I suppose I can step through the contents of the TextBox character by character everytime the content changes, but isn't there a way to detect a "paste" event instead?

Thanks.