exceltadpole
Board Regular
- Joined
- Jan 14, 2004
- Messages
- 108
I am updating an old sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
How do assign the text "Received, Payment Due Immediately" to the current cell ONLY IF the current cell is in the range g100:g220 ?
The user has to scroll thru 200+ cells this would certainly speed up the data entry and avoid spelling mistakes.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
How do assign the text "Received, Payment Due Immediately" to the current cell ONLY IF the current cell is in the range g100:g220 ?
The user has to scroll thru 200+ cells this would certainly speed up the data entry and avoid spelling mistakes.