Vba Worksheet Key Press

Vba Worksheet Key Press. I'm using VBA to dynamically change the worksheet while typing into another cell. So the Sub Sheet_Keypress describes the desired action upon pressing a key.

Selected value in combo box to open another worksheet in ... (Isaac Griffin)

Find answers to Capturing keypress in Excel Worksheet with VBA from the expert community at Experts Hi - Is there a way to capture keypresses in an excel worksheet? Dim ws as Worksheet, wsCollection as Sheets Set wsCollection = Worksheets 'Get entire collection of Worksheets Set ws = Worksheets Worksheets. Because time and keypresses aren't associated with a particular object such as a workbook or a worksheet, you program these events in a normal VBA Pressing PgUp moves you up one row.