Forum Discussion
Solved
Combining the power of goal seek and scenario analysis in a VBA Userform
I’m building a userform (and a module) for a more flexible Goal Seek. I’ve had recurring uses for something like this at work, where I need Goal Seek’s functionality mixed in with some “what if analy...
- The Exit event does not allow setting focus, best use the Change event.
One comment on your code: Don't interrupt the user flow with message boxes appearing on every change. I suggest to place a (red) label on the form that shows the warning.