View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dennis Benjamin Dennis Benjamin is offline
external usenet poster
 
Posts: 12
Default Questions on passng data between UserForm, Module

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!