Advertisement
Guest User

Untitled

a guest
Dec 18th, 2014
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  2.  
  3. Dim origVal As Integer
  4. Dim addVal As Integer
  5.  
  6. Dim targetRange As Range
  7.  
  8. Set targetRange = Target(1, 1)
  9.  
  10. origVal = targetRange.Value
  11. addVal = InputBox("Enter number to add")
  12.  
  13. targetRange.Value = origVal + addVal
  14.  
  15.  
  16. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement