Advice for removing command button & its code

[ipbr21054]

Quite often i find myself changing the look of my user form.

So for example i wish to delete a command button & its code.
I go into the design page & delete the code then open the user form & delete that command button in question.

Is the above the correct way to do it or if not please advise.

I ask as if i delete the command button it leaves the code behind & then i end up with a design page of dead code that isnt assigned to a command button etc.

 

[6StringJazzer]

The way you are doing it is the textbook method, but you have to make sure that you are deleting all the code that references the button, and you have to also make sure that you don't delete code that is needed for something else. If you just have a single Click sub then it's pretty simple and risk-free. (Sometimes people do fancy things with buttons like change the color or caption dynamically based on other actions, which makes it harder to identify which code has to be deleted.)

Leaving the dead code is not harmful but will cause confusion for future maintenance of the code. It's better to remove it.