From form to excel sheet
This is in Excel.
I've created a simple form where to ask the user for a filename location and ask them to put it in a textbox. When they click on OK, the form closes fine. How do I get the program to switch over to the Sheet's code and start doing that?
Please explain what you are wanting to do.
Okay, when I run the Sheet's code, i get it to show a new form to allow the user to enter the filename.
After the user enters the filename in the textbox of that form they click okay. When they click okay, i want the program to return/resume in executing the commands on the Sheet's code.
It really depends on how you are calling the form.
You can place code in the WorkSheet Activate sub that will be run when the worksheet is displayed.