Questions on passng data between UserForm, Module
Where exactly are they declared? I declare my Public variables at the very
top of a general module (or right under Option Explicit) outside of, and
before any subs, functions, or procedures.
Mike F
"Dennis Benjamin" wrote in message
...
Hey All
I'm new to VBA and just getting the hang of it. Would appreciate any help
on the following, where I'm a bit confused about namespaces.
I've written a bunch of code and now need to use a Userform to get input,
specifically values for two variables nAliquots and vAliquots. I'm using a
TextBox, and the only way I could pass the values back to my module
(stored in thisWorkBook) is like so:
Private Sub OK_Click()
ThisWorkbook.GetAliquotValues
Unload Me
End Sub
Where the GetAliquotValues routine pulls the values stored in the TextBox.
It seems kludgy to me to have to call a function back in the WorkBook -
I'd like to be able to do something like
Private Sub OK_Click()
nAliquots = me.TextBox1.Value
vAliquots = me.TextBox2.Value
Unload Me
End Sub
And have the variables in the Workbook loaded w/ the users data. I
declared nAliquots and vAliquots as Public but it didn't work.
So.... is there a straightforward way to share variables between UserForms
and Modules? Or am I thinking about this incorrectly?
Thanks!
|