Return a value from a form? 1

[venkman]

Is there a way to have a custom userform return a value?
like:
dim s as string
s = myform.show

or something?

-Venkman

 

[VulcanJedi]

yes, but your code doesn't make very much sense...
add a control to your form, ie a field (textbox)

add a button (commandbutton)

2x click the button, it should default goto to editor under event:

commandbutton1_click
activesheet.cells(1,1) =textbox1.value

end sub

now write a module:
sub tranpkp()
userform1.show
end sub

run tranpkp, the form will show, type something in the empty field. click the command button. .... BOOM.
Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates others navigating through the threads / posts!

 

[RobBroekhuis]

I don't think you can actually use it to return a value. But you can get a value from any control on the userform (including hidden ones). So for example:

sub main()

  MyForm.show
  
  msgbox(myform.ReturnValue)

  MyForm.unload

end sub()

In the userform code:

sub OKButton_Click()
   ReturnValue= ..... 
   me.hide
end sub

and you'd define a control named "ReturnValue", with visible set to false, on the userform.
Does that help?
Rob

 

[venkman]

I'm sorry, I guess I wasn't speciffic enough. The question I'm asking is not how to set a value in a cell of a sheet to a value gotten from a form. I'm asking if I can get the value gotten from a form to a variable, without using a shared global variable.

For instance if I was able to override the default show sub so that it was now a function which returned a string. then the code I wrote before would work. Or is there a way to access a forms variables after it disappears?

As of now I'm using the shared global variable approach to solve my problem, but I don't like using global variables if I don't have to. I find they make the code harder to read later. Is there a way around using globals?

-Venkman

 

[RobBroekhuis]

Venkman,
Did you see my reply to your post? I think it does what you need.
The form's controls are still accessible after the hide method, until the unload method is executed.
Rob

 

[venkman]

Rob,
You submitted your post as I was typing mine, so I was resonding the first reply. Let me try out your method, and I'll get back to you.
Thanks for the help.
-Venkman

 

[venkman]

Rob,
Your method worked great.
Thanks,
Venkman