Does anyone know how to simplify this code? It's doing the same thing except it's looking at different cell values. And I really don't feel like creating 8 different userforms that the command buttons will be assigned to these. There's got to be a better way of having a command button look at the ranges.
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Dim Found As Range
Dim ProductCode As Range
Set ProductCode = Sheets("Moulder 1").Range("B4")
Set Found = Sheets("Product Code List").Range("A2:A300").Find(What:=ProductCode.value, _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
Found.Offset(0, 2).value = Me.TextPackSize.value
Application.ScreenUpdating = True
End Sub
Private Sub CommandButton2_Click()
Application.ScreenUpdating = False
Dim Found As Range
Dim ProductCode As Range
Set ProductCode = Sheets("Moulder 1").Range("B19")
Set Found = Sheets("Product Code List").Range("A2:A300").Find(What:=ProductCode.value, _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
Found.Offset(0, 2).value = Me.TextPackSize.value
Application.ScreenUpdating = True
End Sub
Private Sub CommandButton3_Click()
Application.ScreenUpdating = False
Dim Found As Range
Dim ProductCode As Range
Set ProductCode = Sheets("Moulder 1").Range("B34")
Set Found = Sheets("Product Code List").Range("A2:A300").Find(What:=ProductCode.value, _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
Found.Offset(0, 2).value = Me.TextPackSize.value
Application.ScreenUpdating = True
End Sub
Private Sub CommandButton4_Click()
Application.ScreenUpdating = False
Dim Found As Range
Dim ProductCode As Range
Set ProductCode = Sheets("Moulder 1").Range("B49")
Set Found = Sheets("Product Code List").Range("A2:A300").Find(What:=ProductCode.value, _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
Found.Offset(0, 2).value = Me.TextPackSize.value
Application.ScreenUpdating = True
End Sub
Bookmarks