Ensuring VBA Update Dont Break Functions

[yrstruly]

Please advice, when brining in or making changes to VBA Code, which measures must i take to prevent the new code from breaking the fom.

I have a form and im trying to upload data. Everytime i run the code im prompted with two form amendments. If i click either or one, then somehow my forms function break, like back or exit buttons dont work anymore. Please see screenshots.


https://docs.google.com/document/d/1...f=true&sd=true

[madpiet]

For starters, are you using error trapping in your code? (Granted, error trapping in VBA is primitive to say the least).

[Welshgasman]

Learn to walk your code with breakpoints and F8

[orange]

See the debugging and Error links in my signature.

[Welshgasman]

I have links in my signature also Jack.

[moke123]

Everytime i run the code im prompted with two form amendments. If i click either or one, then somehow my forms function break, like back or exit buttons dont work anymore. Please see screenshots.

if you don't save the changes to your forms, whatever code you added will not work.