I have a userform that gathers configuration data from the user. When the OK button is clicked, a subroutine in the userform module goes through each textbox in order and does a variety of calculations and assignments. There are 3 textboxes that if they have content in them, I need to gather some more specific data. To do this I pop up a second userform. When the OK button on that form is clicked, I want to return a value to the original calling userform subroutine.
How do I return the value (let's call it price) so that I can incorporate it into my calculations?