Happy Friday!
Today I'm trying to give users the ability to edit data on a sheet using a userform.
Here's a screen shot...
Here's my code:
The user would select data from the combobox, make changes and hit update to edit the data in sheet (GarageHandling).
The current code doesn't error out, but it doesn't edit anything either.
Today I'm trying to give users the ability to edit data on a sheet using a userform.
Here's a screen shot...
Here's my code:
VBA Code:
Private Sub cmdUpdateGarageHandling_Click()
Dim EditGarageHandling_id As String
EditGarageHandling = Trim(EditGarageHandling.Text)
LastRow = Worksheets("GarageHandling").Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To LastRow
If Worksheets("GarageHandling").Cells(i, 1).Value = EditGarageHandling Then
Worksheets("GarageHandling").Cells(i, 1).Value = EditGarageHandling.Text
End If
Next
Call cmdResetDeleteGarageHandling_Click
MsgBox ("Garage Handling Successfully Updated!")
End Sub
The user would select data from the combobox, make changes and hit update to edit the data in sheet (GarageHandling).
The current code doesn't error out, but it doesn't edit anything either.