How Can I '{F4} Key down event' on RefEdit Control?

[Zoo]

I'm trying to make a form like 'Paste Function' Dialog.
And I want to switch the cell address in a RedEdit contorl from/to
AbsoluteAdress<->
Relative Address.
So I type the code below.

Private Sub RefEdit1_KeyDown(KeyCode As Integer, ByVal Shift As Integer)
'115: F4 116:F6
If KeyCode = 115 Then
ChangeRefer
End If

End Sub

However , this does not work.
By Pressing {F4} , the control switch to another floating dialog and no
events happens.

So I want to know how my macro can know that {F4} is pressed by using hook
such as SetWindowLong , GetWindowLong.

I used spy++ to know what messages are sent to the form.
But I could not specify what message make the form switch to the floting
one.

 

[keepITcool]

Hi Zoo,

you can control this using a registry setting..
(it was an original hotfix/workaround on xl2000,
forgotten to set as default in both xl2002 and xl2003
http://support.microsoft.com/?kbid=291110


in
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
Add a DWORD value named "QFE_Richmond"
Set it's value to 1