Rename event VBA subs when controls are renamed.
Renaming form controls leaves orphaned VBA code that was created under the original controls's name.

4 comments
-
Anonymous commented
Rick Fisher's Find and Replace did this nicely and many of us use this on a day to day basis. Unfortunately Rick seems to have disappeared and his F&R is no longer available.
I agree with Tom, there is just no occasion, I can think of, when you would want to rename a control but not change the Event Prefix to match.
-
Tom van Stiphout commented
Unlike Boomer57 I do not consider this optional. If you had a FirstName_AfterUpdate event, and you decided to rename that control to txtFirstName, I would certainly expect it has an AfterUpdate event. Is there a use case to the contrary?
-
Boomer57 commented
Should be optional.
-
Anonymous commented
Yes PLEASE! they did that in VB6 so what not in VBA?