Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Form Values
I've a form that allows the user to enter a filename.
I want the filename entered to be used in another function, the function that calls the form in the first place, but the variable appears to be volatile, ie it's not being passed back to the calling function. How do I get the variable passed back? I could do it by writing it onto the worksheet but is there a way of doing it just with variables? Let me know if you want to see the code. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Form Values
One way is to have a public property in the form and test that afterwards
Dim myForm As UserForm1 If myForm Is Nothing Then Set myForm = New UserForm1 myForm.Show MsgBox myForm.myProp Set myForm = Nothing In the form have a public variable Public myProp as Boolean and set it in the form code. Ensure that in the form you hide when exiting, not unload. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David" wrote in message oups.com... I've a form that allows the user to enter a filename. I want the filename entered to be used in another function, the function that calls the form in the first place, but the variable appears to be volatile, ie it's not being passed back to the calling function. How do I get the variable passed back? I could do it by writing it onto the worksheet but is there a way of doing it just with variables? Let me know if you want to see the code. Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Form Values
Another way is to use a Public variable in a General module (not in the userform
code module). Public MyFileName as String 'or whatever you want. Then this variable will be able to be seen by any procedure. David wrote: I've a form that allows the user to enter a filename. I want the filename entered to be used in another function, the function that calls the form in the first place, but the variable appears to be volatile, ie it's not being passed back to the calling function. How do I get the variable passed back? I could do it by writing it onto the worksheet but is there a way of doing it just with variables? Let me know if you want to see the code. Thanks! -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Form Values
A form property can be seen by any procedure as well.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave Peterson" wrote in message ... Another way is to use a Public variable in a General module (not in the userform code module). Public MyFileName as String 'or whatever you want. Then this variable will be able to be seen by any procedure. David wrote: I've a form that allows the user to enter a filename. I want the filename entered to be used in another function, the function that calls the form in the first place, but the variable appears to be volatile, ie it's not being passed back to the calling function. How do I get the variable passed back? I could do it by writing it onto the worksheet but is there a way of doing it just with variables? Let me know if you want to see the code. Thanks! -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Form Values
But I don't have to worry about hiding or unloading (after I change the
variable). Bob Phillips wrote: A form property can be seen by any procedure as well. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave Peterson" wrote in message ... Another way is to use a Public variable in a General module (not in the userform code module). Public MyFileName as String 'or whatever you want. Then this variable will be able to be seen by any procedure. David wrote: I've a form that allows the user to enter a filename. I want the filename entered to be used in another function, the function that calls the form in the first place, but the variable appears to be volatile, ie it's not being passed back to the calling function. How do I get the variable passed back? I could do it by writing it onto the worksheet but is there a way of doing it just with variables? Let me know if you want to see the code. Thanks! -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Form Values
Dave, you don't have to worry anyway. It's only Excel.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave Peterson" wrote in message ... But I don't have to worry about hiding or unloading (after I change the variable). Bob Phillips wrote: A form property can be seen by any procedure as well. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave Peterson" wrote in message ... Another way is to use a Public variable in a General module (not in the userform code module). Public MyFileName as String 'or whatever you want. Then this variable will be able to be seen by any procedure. David wrote: I've a form that allows the user to enter a filename. I want the filename entered to be used in another function, the function that calls the form in the first place, but the variable appears to be volatile, ie it's not being passed back to the calling function. How do I get the variable passed back? I could do it by writing it onto the worksheet but is there a way of doing it just with variables? Let me know if you want to see the code. Thanks! -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Form Values
I think it was that Excel wunderkind who sang:
It's only Excel, but I like it.... (it almost scans...) http://www.mp3lyrics.org/r/rolling-s...y-rock-n-roll/ Bob Phillips wrote: Dave, you don't have to worry anyway. It's only Excel. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave Peterson" wrote in message ... But I don't have to worry about hiding or unloading (after I change the variable). Bob Phillips wrote: A form property can be seen by any procedure as well. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave Peterson" wrote in message ... Another way is to use a Public variable in a General module (not in the userform code module). Public MyFileName as String 'or whatever you want. Then this variable will be able to be seen by any procedure. David wrote: I've a form that allows the user to enter a filename. I want the filename entered to be used in another function, the function that calls the form in the first place, but the variable appears to be volatile, ie it's not being passed back to the calling function. How do I get the variable passed back? I could do it by writing it onto the worksheet but is there a way of doing it just with variables? Let me know if you want to see the code. Thanks! -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing variable to and from a form | Excel Programming | |||
Passing Controls on a form between modules | Excel Programming | |||
User Form value passing problem | Excel Programming | |||
passing control value from one form to another form | Excel Programming | |||
Passing data back from a form | Excel Programming |