Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1043
  • Last Modified:

pass data from a userform to a userform word vba

I have a userform that gathers configuration data from the user. When the OK button is clicked, a subroutine in the userform module goes through each textbox in order and does a variety of calculations and assignments. There are 3 textboxes that if they have content in them,  I need to gather some more specific data. To do this I pop up a second userform.  When the OK button on that form is clicked, I want to return a value to the original calling userform subroutine.

How do I return the value (let's call it price) so that I can incorporate it into my calculations?

0
karimjohnson
Asked:
karimjohnson
  • 4
  • 3
1 Solution
 
Chris BottomleyCommented:
Casll the second form from the first BUT when clicking the second button HIDE the second form:

Private Sub CommandButton1_Click()
    Me.Hide
End Sub

Processing returns to your first userform and the data is displayed and in the outline below the form is redisplayed but of course you can use the data and store it somewhere ending with an unloaf of userform1 if required.

Chris
Private Sub CommandButton1_Click()
    Me.Hide
    Load UserForm2
    UserForm2.Show
    Me.TextBox1 = UserForm2.TextBox1.Text
    Unload UserForm2
    Me.Show
End Sub

Open in new window

0
 
karimjohnsonAuthor Commented:
If I understand correctly, this assumes I am passing the value of a userform field in userform2 back to a userform field in userform1. Is there a way to pass a calculated value from userform2 (for example, listbox1*listbox2) back to a variable set in the module associated with userform1 (rather than a form field)? Otherwise, I think I will have to create hidden fields for the return values (since they are not part of what I want the user to see).
0
 
Chris BottomleyCommented:
Any data from userform2 is passed back to userform1 by such a mechanism whether userform1 does the calculation on teh data or whether userform2 does the calculation and it's made available to userform1.

Chris
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
karimjohnsonAuthor Commented:
so I could modify it like so?

Sub cmdOK_Click()
[other code here...]

    Me.Hide
    Load UserForm2
    UserForm2.Show
    Me.CalculatedPrice= UserForm2.CalculatedPrice 'where calculated price is listbox1 * listbox2 after OK
    Unload UserForm2
    Me.Show
End Sub
0
 
Chris BottomleyCommented:
INdeed.

Chris
0
 
karimjohnsonAuthor Commented:
ok, i'm close. can you look at this file and see why the variables are not accessible to the Userform1 subroutine cmdOK_click? I'm sure it is something simple.
Doc3.doc
0
 
Chris BottomleyCommented:
variables scoped to the checkbox routine are not available to the ok sub.

I redeclare them here as global and therefore it works:

Chris
Public price As String
Public license As String

Public Sub CheckBox1_Click()

    Load UserForm2
    UserForm2.Show
    price = UserForm2.TextBox1.Text
    license = UserForm2.TextBox2.Text
    Unload UserForm2

MsgBox prompt:="Price: " & price, buttons:=vbOKOnly
MsgBox prompt:="License: " & license, buttons:=vbOKOnly

End Sub

Public Sub cmdOK_Click()

MsgBox prompt:="Price: " & price, buttons:=vbOKOnly
MsgBox prompt:="License: " & license, buttons:=vbOKOnly

Unload Me
End Sub

Private Sub cmdCancel_Click()
Unload Me
End Sub

Private Sub UserForm_Click()

End Sub

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now