ndfightingirish1971
New Member
- Joined
- May 14, 2013
- Messages
- 6
I have what should be a simple problem but I have been racking my brain trying to figure out what I am doing wrong. I collect data using a wireless device that sends a signal to the PC and thus into Excel. Once the number is populated into a cell, it automatically moves to the next cell to the right (in my case, I have the move direction set to right). If the operator makes a mistake collecting the data, I created a button to allow them to go back one cell, delete the data, and retake the data. The problem with my code is that it does not delete the data. Can anyone please help me? Thanks!
Code:
Sub RETAKE_POINT()
SendKeys "+{Tab}"
Selection.ClearContents
End Sub
Code:
Sub RETAKE_POINT()
SendKeys "+{Tab}"
Selection.ClearContents
End Sub