I have 10 cells named UI1 through UI10.  I want to put data into the
cells through a For loop.  What is the proper syntax to use a variable
as part of the object name?

In the sample below, CELL1 is a variable whose value is the name of
the field where I want to enter data.  I need to have VB recognize the
value of the variable as the field name.

Dim Cell1, DATA1 as variant
Dim x as integer

<DATA1 - calculated >
For x = 1 to 10
CELL1 = "UI" & x
            RS.Edit
            RS!CELL1 = Data1  --   Error - What is the proper
syntax?
            RS.Update
    <Change Data1>
Next x

Smitty