Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim origVal As Integer
- Dim addVal As Integer
- Dim targetRange As Range
- Set targetRange = Target(1, 1)
- origVal = targetRange.Value
- addVal = InputBox("Enter number to add")
- targetRange.Value = origVal + addVal
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement