|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 8th, 2003, 11:10 AM
|
|||
|
|||
|
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?
|
|
#3
July 8th, 2003, 11:26 AM
|
|||
|
|||
|
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.
|
|
#4
July 8th, 2003, 11:44 AM
|
||||
|
||||
|
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.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > From form to excel sheet |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
