I am trying to use user forms to build a program in excel. I would lik
it to use all user forms. When a certain item on one form is selecte
it calls another form. My problem is that I need to pass informatio
between the forms so I can total prices that are selected on th
multiple forms, I'm not sure how to pass this data between the forms.

Thank You for any suggestions.

Micki

--
Message posted from http://www.ExcelForum.com

hide the first form. the second form can then access the data

in userform1

Private Sub CommandButton1_Click()
me.hide
userform2.show
End Sub


in userform2

Private Sub CommandButton1_Click()
if Userform1.Combobox1.Value = "House" then
' do something
elseif Userform1.Combobox1.Value = "Dog" then
' do something else
end if
End Sub

as an example.

--
Regards,
Tom Ogilvy

"mickiedevries " wrote in
message ...
I am trying to use user forms to build a program in excel. I would like
it to use all user forms. When a certain item on one form is selected
it calls another form. My problem is that I need to pass information
between the forms so I can total prices that are selected on the
multiple forms, I'm not sure how to pass this data between the forms.

Thank You for any suggestions.

Mickie


---
Message posted from http://www.ExcelForum.com/

Thanks for the help, but how do I pass the information in a variable?

For instance when a radio button is selected on form1 an amount i
assigned to variable1 (but not shown on the form) and then form2 i
shown. I want form2 to be able to utilize variable1 from form1. I'
assuming I still have to hide form1 but how do I get the value fro
form1 I tried the following but it did not work:

UserForm1.Variable1.Value

Thanks Again,

Micki

--
Message posted from http://www.ExcelForum.com

If you make the variable public at the top of the userform code module, then
it should work.

--
Regards,
Tom Ogilvy

"mickiedevries " wrote in
message ...
Thanks for the help, but how do I pass the information in a variable?

For instance when a radio button is selected on form1 an amount is
assigned to variable1 (but not shown on the form) and then form2 is
shown. I want form2 to be able to utilize variable1 from form1. I'm
assuming I still have to hide form1 but how do I get the value from
form1 I tried the following but it did not work:

UserForm1.Variable1.Value

Thanks Again,

Mickie


---
Message posted from http://www.ExcelForum.com/