hi, this is what I have on the Lisbox_click. It fetches the data and shows it in the text boxes. Now i need to figure out how to edit the data in the text boxes. for exemple, if I need to modify a person's last name, I'd like to be able to simply click the box and write the correct name and have the cell updated. As mentioned above, it has to be on the Change event..I just don't know how.
Private Sub ListBox_Click()
Dim result As String
Dim sheet As Worksheet
Set sheet = Worksheets("Data")
mylookup = Me.ListBox.Value
Me.casenumber = Application.WorksheetFunction.VLookup(mylookup, sheet.Range("A4:as8000"), 1, False)
Me.store_num = Application.WorksheetFunction.VLookup(mylookup, sheet.Range("A4:As8000"), 4, False)
Me.store_name = Application.WorksheetFunction.VLookup(mylookup, sheet.Range("A4:As8000"), 5, False)
Me.case_type = Application.WorksheetFunction.VLookup(mylookup, sheet.Range("A4:As8000"), 7, False)
Me.case_value = Application.WorksheetFunction.VLookup(mylookup, sheet.Range("A4:As8000"), 8, False)
case_value.Value = Format(case_value.Value, "Currency")
Me.name_last = Application.WorksheetFunction.VLookup(mylookup, sheet.Range("A4:As8000"), 9, False)
Me.name_first = Application.WorksheetFunction.VLookup(mylookup, sheet.Range("A4:As8000"), 11, False)
thanks