Detecting a PASTE event related to a UserForm TextBox.

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.

Thanks Norie.

Not to seem lazy but, would you have time to shed some light on how to implement that event?

I think I can deal with writing the code that I want to process once this event is detected.

I created the sub like I believe it needs to be per the syntax listed in the vba help section, but I get an error. I was hoping for some help with the actual sytax of sub.

Thanks.

Thank you again Norie.

I had a typo in before. As usual, couldn't see the forest for the trees.

It works great now.