I have a form with 4 different text boxes in a form. When a command
button is pressed on the form, the values are saved into variables
that I want to use in a module sub saved in the same excel workbook,
but i seem to be striking out... How do i accomplish this?

Dim the variables as public in the declarations section of any module. e.g....

Public myInt as Integer
Public myStr as String, myWksh as Worksheet
etc...

This allows whatever is stored in them to be retained beyond the execution
of a specific module that is assigning values to them.

"Matthew Dyer" wrote:

I have a form with 4 different text boxes in a form. When a command
button is pressed on the form, the values are saved into variables
that I want to use in a module sub saved in the same excel workbook,
but i seem to be striking out... How do i accomplish this?

On Oct 7, 1:58*pm, B Lynn B wrote:
Dim the variables as public in the declarations section of any module. e.g....

Public myInt as Integer
Public myStr as String, myWksh as Worksheet
etc...

This allows whatever is stored in them to be retained beyond the execution
of a specific module that is assigning values to them.



"Matthew Dyer" wrote:
I have a form with 4 different text boxes in a form. When a command
button is pressed on the form, the values are saved into variables
that I want to use in a module sub saved in the same excel workbook,
but i seem to be striking out... How do i accomplish this?- Hide quoted text -

- Show quoted text -

I figured out my problem. My variable had the same name as the text
box in my user form. Switched it around and it's working perfectly!