help with indexing

[xxentric]

the code im working with below wont work becuase it is telling me "'text' is not a member of 'string'" how would i go about doing this

** i have 15 text boxes on this form labeled fix1 - fix15, which is why im trying to do this instead of repeating code for each item

        Public Fix(0 To 50) As String
        i = 1
        Do Until i = 10
            oSheet.Range("L" + (i)).Value = Fix(i).Text
            i = i + 1
        Loop

 

[NiceArms]

maybe replace fix(i).Text to Fix(i).Tostring??

Just a bit of a guess on my part.

 

[DaveInIowa]

From your original post it appears you are working under the notion that Fix(2) is TextBox Fix2. This is not the case; Fix(2) is just an element of a string array and as such, is a String, not a TextBox and does not have any association with your fix1 - fix15 text boxes.