afrazier1221
New Member
- Joined
- Jul 23, 2023
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
I have this:
The code result reverses itself at 10 and produces essentially a mirrored result.
What I should get:
What I actually get:
I'm not sure why it's doing this. Any thoughts?
On the UserForm in question, there are eighteen textboxes, named CDTB1 through CDTB18 (Customer Data Text Box). The loop is meant to populate the form fields from Sheet5, Cells AO1 through AO18 (Rows 1 through 18, Column 41).Dim contr As Control
C = 1
For Each contr In UserForm1.Controls
If Left(contr.Name, 4) = "CDTB" Then
contr.Value = ""
contr.Value = Sheet5.Cells(C, 41).Value
C = C + 1
End If
Next
The code result reverses itself at 10 and produces essentially a mirrored result.
What I should get:
What I actually get:
I'm not sure why it's doing this. Any thoughts?