Hi All,
i have a spreadsheet showing materials arriving for delivery into a warehouse and I need to force the kilos being delivered to be entered when the pallets column has a number greater than zero entered.
Pallets in column K rows 2 - 32 and column S rows 2 - 32
I need to force people to enter data into column L if data is entered in column K and column T if data is entered in column S
I copied the below but I can only get it to work for columns K/L - need to know how / if I can amend this to run for the second set of columns too
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim myC As Range
For Each myC In Range("K2:K32")
If myC.Value <> "" And myC(1, 2).Value = "" Then
Application.EnableEvents = False
myC(1, 2).Select
MsgBox "Enter a value into cell " & myC(1, 2).Address & ", please"
Application.EnableEvents = True
End If
Next myC
End Sub
Thanks in advance
Bookmarks