Hello,

I have a userform which collects from a TextBox "Names" on CommandButton1_Click()

The userform is initiated through a macro in Module1

What I am after, is to pass the Names.Value into Module1.
I tried to declare the Name as public, and Global, but it won't do the trick.
Could you please advise?
Thanks