Prev: setting more than one filter
Next: Sorting one worksheet from another worksheet
From: Phyllis on 22 Apr 2010 17:27
I can't find the answer to this. I want to turn off the pageup and pagedown
function only when a combobox has been clicked. My user gets confused and
hits pagedown before exiting the combobox and changes her desired choice from
the combobox.

Is there a way to disable it?
From: john on 23 Apr 2010 04:11
see if this does what you want.

Sub disablekeys()

With Application

.OnKey "{PGDN}", ""

.OnKey "{PGUP}", ""

End With

End Sub


Sub enablekeys()

With Application

.OnKey "{PGDN}"

.OnKey "{PGUP}"

End With

End Sub



--
jb


"Phyllis" wrote:

> I can't find the answer to this. I want to turn off the pageup and pagedown
> function only when a combobox has been clicked. My user gets confused and
> hits pagedown before exiting the combobox and changes her desired choice from
> the combobox.
>
> Is there a way to disable it?
 | 
Pages: 1
Prev: setting more than one filter
Next: Sorting one worksheet from another worksheet