Microsoft Excel - VBA SendKey toggles Num Lock Key when it is used

I am using Excel 2010.  I have several embedded active x boxes on a sheet and the EnterFieldBehavior property when set to select all does nothing when I sellect the combobox.  I thought this would be easy to fix by a SendKeys "^a" in the gotfocus event.  This does select the contents of the combobox but the SendKeys method toggles the NumLock key. Any Ideas on how I can either get EnterFieldBehavior to work or SendKeys to stop toggeling the NumLock. 

Bill,

I was courious to see what the CHR$ was for the numlock key and did a google search for it, the first link was this article about sendkeys and numlock
http://access.mvps.org/access/api/api0046.htm

It seems that this is a known issue and has been for a while. 

Don

sorry wrong cut and paste but this is the first one I read http://bytes.com/topic/access/answers/204751-solution-access97-sendkeys-command-disables-numlock

Thanks Don, I tried the SendKeys chr$(144) as the last statement.  It errased the contents of the ComboBox.  The easiest solution would be if I could get the .EnteFieldBehavior property to do what it is suppose to do in Active X controls.  Any ideas on this?  I coppied the code from the Other link you sent that creates a different method to send keys.  I will try it as see if it works.  All I want to do is Select the entire contents of the ComboBox when it gets the focus.  
Bill

Don, the link you sent me to the alternate SendKeys (mySendKeys) worked.  All I had to do was copy the code into a new Module and it fixed the key toggling issue thanks again your help got me back to programming and not chasing gliches.
THANKS AGAIN,
Bill

your welcome Bill.

Post again and dont forget to help others answer questions from time to time. I have learned more here than I have in a long time just doing research.

Don