Solved

Excel VBA - need a reliable method for SendKeys Number lock

Posted on 2016-11-28
4
52 Views
Last Modified: 2016-12-01
I see that {Numlock} toggles the Number lock.

I'm looking for a reliable way to ensure that, after my Sendkeys {Down} which sometimes leaves Number Lock state as 'off', to ensure that it is returned to Number Lock 'on'.

Thanks.
0
Comment
Question by:hindersaliva
4 Comments
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 125 total points
ID: 41904565
You can get the state from the GetKeyState Windows API
1
 
LVL 69

Accepted Solution

by:
Qlemo earned 250 total points
ID: 41904608
You know that SendKeys and reliable are contradictory? You should avoid using SendKeys as much as possible.
1
 
LVL 7

Assisted Solution

by:Mike in IT
Mike in IT earned 125 total points
ID: 41904704
I agree with Qlemo, you should avoid SendKeys. It is not reliable. Here is a link to a possible way to work around it with an API.
0
 

Author Closing Comment

by:hindersaliva
ID: 41909035
Thanks. I've taken Qlemo's advice and am NOT using SendKeys.
I shall try Mike in IT's link later.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question