none
Key Functionality for Num Lock and Cap Lock is toggling incorrectly the first time I run VBA code from a User Form. RRS feed

  • Question

  • Hello,

    I am having an issue where when I add data to a spreadsheet(table) from a User Form for the first time after opening the the workbook. It is toggling the NumLock and the CapLock key functionality to its opposite state from what I have it set at when I open the workbook. I have on vba/macro code that in the workbook that touches these key states. Is there an option setting or some other feature that needs to modified to prevent this from happening. The key functionality does return to what it was prior to the running of the vba/macro code once I exit the workbook. I am using Excel 2010 (32-bit) on a Windows 7 (32-bit) system.

    TIA

    Thursday, November 13, 2014 3:48 PM

All replies

  • Put a breakpoint on the line of code that toggles and see if its running at times you don't expect or with variable not set as expected.

    Thursday, November 13, 2014 4:25 PM