update data based on listbox & textbox

[SarahPintal]

Hi guys,

I am stressing out a tad as I cant seem to get this to work. I guess I dont understand coding enough...

Currently I can;
1. populate a Listbox
2. based on the listbox details can transpose that data into various textboxes.

What i cant do is workout if someone updates\changes the data within the text boxes how to update the data on a worksheet.

I cant seem to work out how to find the row's address and then reference off of that to find the row of the selected list box entry and thus move along the row to update.


I have attached my WB.. if one were to launch the user form > search for a user (i.e. Pintal), the users details will appear but then i need to create some code to update.

I have failed to work this out in 5 hours so i dont think im going to work it out without your help unfortunatly,,,

Thanks in advance,

[SarahPintal]

I was able to do a work around: instead of using the ROW number i used the SKU number (unique to each entry)

Private Sub CommandButton3_Click()
    Dim strFind As String    'what to find
    Dim firstAddress As String
    Dim rSearch As Range  'range to search
    Set rSearch = Sheet1.Range("D:D")
    Dim f      As Integer

    strFind = Me.SKU.Value 'what to look for
                                 
    With rSearch
        Set C = .Find(strFind, LookIn:=xlValues)
        If Not C Is Nothing Then    'found it
C.Offset(0, 1).Value = Me.VIP.Value
End If
End With
MsgBox "Customer details updated"
End Sub

I would still very much like to know how to work this out via just the rows address.

[royUK]

You do realise that the size of your form is excessive & will not fit correctly on some screens?

[rylo]

Hi

listview1.selecteditem

defaults to the row number in the item selected. Isn't this what you are chasing?

rylo

[SarahPintal]

Roy - no i did not know that - ive used it on 2 differnt computers and they all fit - maybe ill play around with the Res and see how it looks.


rylo - thanks, ill give it ago as my code works fine now, though it would be cleaner to reference the row.

will advise back,

thanks,