Updating Data From UserForm

[reberryjr]

I have a form that is pulling data from a worksheet, contingent upon the selection made from a combobox. I've coded other forms to update worksheets, but I'm struggling to find anything that makes sense, that guides me on how to code so that when a command button is clicked, the data sheet is updated on the same row where the combobox value is found. Example: If I have 5 names (Bob, Tom, Jim, Dave, Harry) and Bob is selected from the combobox. The User updates some data that is presented in the form. I want the updated data elements to update on the worksheet, when the User clicks a command button.

 

[Norie]

How are you populating the userform based on the selected name in the combobox?

 

[My Aswer Is This]

If you choose "Bob" from the Combobox where should we search for "Bob"

Should we search column A B C or which column.

I suspect you should give us more details. I believe this is just one part of a larger script your working on.
And more questions will follow.

 

[reberryjr]

Here is the code that retrieves the data. Not sure if I did the code tags correctly or not.

Private Sub cobo_Name_DropButt*******()


Dim i As Long
Dim LastRow As Long


LastRow = Sheets("Client Info").Range("F" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow


If Sheets("Client Info").Cells(i, "F").Value = (Me.cobo_Name) Or _
Sheets("Client Info").Cells(i, "F").Value = Val(Me.cobo_Name) Then
    Me.txt_First = Sheets("Client Info").Cells(i, "C").Value
    Me.txt_Last = Sheets("Client Info").Cells(i, "D").Value
    Me.txt_Suffix = Sheets("Client Info").Cells(i, "E").Value
    Me.txt_Phone = Sheets("Client Info").Cells(i, "K").Value
    Me.txt_Email = Sheets("Client Info").Cells(i, "L").Value
    Me.txt_DPStart = Sheets("Client Info").Cells(i, "M").Value
    Me.txt_DCStart = Sheets("Client Info").Cells(i, "N").Value
    Me.txt_OCStart = Sheets("Client Info").Cells(i, "O").Value
    Me.txt_CTIStart = Sheets("Client Info").Cells(i, "P").Value
    Me.txt_CTOStart = Sheets("Client Info").Cells(i, "Q").Value


End If
Next
End Sub

 

[My Aswer Is This]

edit

 

[Norie]

In that code you are searching column F for the name selected in the combobox using a loop to go through the rows.

When/if you find the name the loop variable i will be the row in which you've found the name, so you can use that variable/value to write back update the row the name was found in.

 

[reberryjr]

Thank you Norie! That was what I was struggling with...how to update the same row, from a different piece of code. As you can see, I'm still new to VBA, but with help like yours, I'm navigating it. Thank you again!