devxlogo

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
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist