Originally Posted by bgmsd

I am using Legacy text boxes because I like the formatting controls. I can prevent users from typing text in number only text boxes. Some text boxes should only have currency values, others should have numbers without decimal values.

If I use Content Controls, I can check the box to prevent users from deleting the content control, but they do not have any validation functionality. I could send the data to a VBA sub to do my own validation, but I don't see how I can fire an event after a user changes data in a content control.

Does anyone have any suggestions?