I am new to using userforms and struggling.. so if anybody has a tip:
I want the user to input a (week)number in a userform and then find this number in my worksheet. I can't seem to match the userform value with the sheet value.
Code is as follows:
Private Sub OK_Click()
Range("A8").Select
ActiveCell(1, 14).Select
If ActiveCell.Value = Planweeknr.Value Then
ActiveCell.Rows("1:1").EntireRow.Select
Selection.Copy
End If
please?
I want the user to input a (week)number in a userform and then find this number in my worksheet. I can't seem to match the userform value with the sheet value.
Code is as follows:
Private Sub OK_Click()
Range("A8").Select
ActiveCell(1, 14).Select
If ActiveCell.Value = Planweeknr.Value Then
ActiveCell.Rows("1:1").EntireRow.Select
Selection.Copy
End If
please?