Suppress User Keypress Momentarily
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I have an iLogic that does some handy things with the revision table to automate removing revision tags and adding a new revision.
At the end of the iLogic, I open the revision table and use SendKeys to navigate to the description cell of the new revision row so that the user can fill that in.
However, if the user starts typing too quickly, their input will get put in the (1,1) cell of the revision table (i.e. the revision letter of the furthest back revision in the table) and overwrite it accidentally, which if they don't catch that can cause problems.
Is there a way I can temporarily suppress key inputs until the sendkeys has completed? Or perhaps a better way to get to the cell other than using SendKeys?
oCommandMgr.ControlDefinitions.Item("DrawingRevisionTableEditCtxCmd").Execute2(False) 'open the rev table for editing SendKeys.SendWait("{DOWN}{DOWN}{RIGHT}") 'press down down right arrow keys to position user on description cell of current rev (works with both 2 and 3 rev lines)
P.s. - I am aware that I could just use an inputbox to get the description text without ever opening the revision table, but sometimes other columns need to be filled in. While I could create a custom form that would meet my needs, I'd prefer to see if there's a way I can just prevent the user from typing until the cursor is moved to the correct cell before going that route.