I have a module containing a number of Public string
variables.  If I refer directly to them, there is no
problem.  ie.
offno = "001"

I would like to know if there is any way to refer to them
with a variable. ie

variablename = "offno"

something.something.(variablename) = "001".

I have made it work by using a case statement. ie.

Select Case variablename
     Case "offno"
          offno = "001"

etc.

This is not what I am looking for.  It seems that there
should be a way to do it with that one line.  If there is,
I would just like to know how to do it.
(I have referred to textboxes on a form with:
Forms!FormName.Controls.(textboxname).Visible = True
It just seems like there should be something similar for
global variables in a module.

Using a recoredset list of variable names, I can loop
through the list and assign values to some properties of
textboxes on a form:

textboxname = "Inp" & rs!variablename
Forms!Form1.Controls.(textboxname).visible = True

This works nicely.  I have a module (Globals) with some
global variables to which I would like to refer in the
same way. ie:

globalvariablename = rs!variablename
something.something.variablename = "001"

I have a working solution for moving the data to the
globals using a case statement with two lines for each
global variable.  I just seems that there should be some
direct way of doing it the way I can refer to the
textboxes.  Can it be done and how?