#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    4
    Rep Power
    0

    From form to excel sheet


    Hi everyone,
    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?
  2. #2
  3. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    Please explain what you are wanting to do.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    4
    Rep Power
    0
    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.
  6. #4
  7. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    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.

IMN logo majestic logo threadwatch logo seochat tools logo