Help regarding SendKeys command in Macro turning off NumLock key

[morant05]

I apologize in advance if I omit some info..please let me know if I do.

Basically, I have a spreadsheet with a macro that will automatically open a Comment box whenever a cell is populated with any characters. However, the macro uses a SendKeys command, which, from what I gather around the web, can be problematic. And mine is. it runs off the NumLock key when the macro is enabled. Now, overall, it's not a big thing to click the NumLock key to re-activate it, but I was hoping for a solution to this. I've tried a few ways (based on what I found on the web) to re-write this, but no luck. Can some help me with this? Here is the macro:

Please Login or Register  to view this content.

Any help would be appreciated.

[Mordred]

Hi morant05 and welcome to the forum. Please take a moment to read the forum rules located here. You need to amend your title according to Rule #1 and also wrap your code in code tags as per Rule #3. Once you do that, someone will be able to help you.

[ovann86]

Old post - I see no one has replied, but but did you have any success with this?

I'm using EPOS4Excel (EPOS 3 Excel) which has the same issue.