When to Use SendKeys

When to Use SendKeys

Use the SendKeys function to exploit the delete functionalityof many grid and spreadsheet controls that have a delete functionality.Use this functionality without writing code to delete each rowif your form has an option that deletes all highlighted rows.This method works much faster than writing code to check for eachhighlighted row in the grid, and then deleting that row.

Remember not to use SendKeys to send a key value without firstsetting the focus of the control to which you are sending thekey value.

Call this procedure to simplify the process:

 'Pass the Key value to send and the 'Control to which the value to be sentSub SendKeyTo(KeyValue As String, cCnt _         As Control)                  cCnt.SetFocus         SendKeys KeyValue         End Sub


Share the Post: