Pass combo box value to string variable in module

[magix]

Hi,

In the OK button click event, how can I pass back the selected
"me.Combobox1.Value" to my module ?
The combo box is in userform.

Usually in my module, I define a string variable.
e.g
sub Test()
Dim fname as string
...
...
end sub

So how can pass the combox value to variable fname in my Test Module
directly?
Note: I don't want to pass the combox value to cell, and then use fname to
read from cell.

Thanks.

Regards, magix

[Dave Peterson]

Declare Fname as Public at the top of your module, but inside that General
module.

Option Explicit
Public fname as string
sub test()
....
end sub

is one way.

magix wrote:
>
> Hi,
>
> In the OK button click event, how can I pass back the selected
> "me.Combobox1.Value" to my module ?
> The combo box is in userform.
>
> Usually in my module, I define a string variable.
> e.g
> sub Test()
> Dim fname as string
> ...
> ...
> end sub
>
> So how can pass the combox value to variable fname in my Test Module
> directly?
> Note: I don't want to pass the combox value to cell, and then use fname to
> read from cell.
>
> Thanks.
>
> Regards, magix

--

Dave Peterson