Is there a way to have excel only let the user select one cell at a time? The code I have displayed below, gives me an error everytime a user selects more than one cell at a time.....
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection = Range("b10"
Then
Range("B10"
.Value = (InputBox("Scan or Type Assembly Part Number", "NORTECH SYSTEMS INC."
)
Range("B100"
.Value = (InputBox("Scan or Type Sequence Number", "NORTECH SYSTEMS INC."
)
Range("d10"
.Formula = "=IF(ISBLANK(B100)=TRUE,TRIM(CHAR(32)),MID(b100,3,6))"
Range("f10"
.Formula = "=IF(ISBLANK(B100)=TRUE,TRIM(CHAR(32)),MID(b100,16,2))"
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection = Range("b10"
Range("B10"
Range("B100"
Range("d10"
Range("f10"
End If
End Sub