Scenario: Userform with 5 contact fields at the top made from textboxes (First, Last, Title, Phone, Email,) that I attempting to populate a 5x6 table below that I have created using textboxes (contact1,2,3...) on the same userform. I have a command button I would like to use to populate a contact row and clear the contact fields each time I fill the contact fields and press the button (fill contact fields, press button, populate row 1, fill contact fields, press button, populate row 2.... ). I think I need to incorporate a "control" variable, but I have been writing code now for 14hrs and my brain is not working at peak efficiency. Any help is greatly appreciated!
![]()
Private Sub Image236_Click() Dim i As Integer Dim j As Integer Dim x As Integer Dim ContactCounter As Integer For i = 0 To 4 Select Case ContactCounter Case 0 j = i + 100 For x = 0 To 4 If Me.Controls("TextBox" & i).Value <> "" Then Me.Controls("TextBox" & j).Value = Me.Controls("TextBox" & i) Me.Controls("TextBox" & i).Value = "" End If Next x Case 1 j = i + 200 For x = 0 To 4 If Me.Controls("TextBox" & i).Value <> "" Then Me.Controls("TextBox" & j).Value = Me.Controls("TextBox" & i) Me.Controls("TextBox" & i).Value = "" End If Next x Case 2 j = i + 300 For x = 0 To 4 If Me.Controls("TextBox" & i).Value <> "" Then Me.Controls("TextBox" & j).Value = Me.Controls("TextBox" & i) Me.Controls("TextBox" & i).Value = "" End If Next x Case 3 j = i + 400 For x = 0 To 4 If Me.Controls("TextBox" & i).Value <> "" Then Me.Controls("TextBox" & j).Value = Me.Controls("TextBox" & i) Me.Controls("TextBox" & i).Value = "" End If Next x Case 4 j = i + 500 For x = 0 To 4 If Me.Controls("TextBox" & i).Value <> "" Then Me.Controls("TextBox" & j).Value = Me.Controls("TextBox" & i) Me.Controls("TextBox" & i).Value = "" End If Next x Case 5 j = i + 600 For x = 0 To 4 If Me.Controls("TextBox" & i).Value <> "" Then Me.Controls("TextBox" & j).Value = Me.Controls("TextBox" & i) Me.Controls("TextBox" & i).Value = "" End If Next x Case 6 MsgBox "Max number of contacts for this contractor has been reached" Exit Sub End Select Next i ContactCounter = ContactCounter + 1 End Sub
Bookmarks