Thank you works Brilliantly I just put Application.EnableEvents = false
before the function calls and then
Application.EnableEvents = true
after the calls to enable the updating functions to keep working.
1 button functionality works again!!!
Thanks again [thumbsup2]
I have a form which carries out a very simple calculation giving intermediate output to 3 text boxes which each have controlsources in a sheet.
If I run the macro the first control will update but not the other two - however if I run the control again the second one will update and finally if I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.