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
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
