Capture ENTER

I have some code in Worksheet_SelectionChange (ByVal Target As Range)

I want to redirect the activecell to another place when the user hits ENTER
(actually would like it to move the focus to my combobox).

I am not able (or don't understand) how to accomplish this. I have tried
the Target = 13 in other places in my code with comboboxes and keydown and it
works, but it doesn't work in this sub. Any suggestions?
--
Thanks - Ed

Hi Ed,

Ed wrote:
> I have some code in Worksheet_SelectionChange (ByVal Target As Range)
>
> I want to redirect the activecell to another place when the user hits
> ENTER (actually would like it to move the focus to my combobox).
>
> I am not able (or don't understand) how to accomplish this. I have
> tried the Target = 13 in other places in my code with comboboxes and
> keydown and it works, but it doesn't work in this sub. Any
> suggestions?

The SelectionChange event will fire when the user's selection changes from
one cell or range to another. The Target argument is a Range object that
references the newly-selected range. So I don't think you need to trap the
Enter key - I think you could just trap the event and move to your ComboBox
based on the new selection.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

I actually want two different things to happen. If the user uses TAB, he
should move to the next cell. If he hits ENTER, I want him to move back to
the first column and activate the combobox. This is why I wanted to capture
the ENTER.
--
Thanks - Ed


"Jake Marx" wrote:

> Hi Ed,
>
> Ed wrote:
> > I have some code in Worksheet_SelectionChange (ByVal Target As Range)
> >
> > I want to redirect the activecell to another place when the user hits
> > ENTER (actually would like it to move the focus to my combobox).
> >
> > I am not able (or don't understand) how to accomplish this. I have
> > tried the Target = 13 in other places in my code with comboboxes and
> > keydown and it works, but it doesn't work in this sub. Any
> > suggestions?
>
> The SelectionChange event will fire when the user's selection changes from
> one cell or range to another. The Target argument is a Range object that
> references the newly-selected range. So I don't think you need to trap the
> Enter key - I think you could just trap the event and move to your ComboBox
> based on the new selection.
>
> --
> Regards,
>
> Jake Marx
> www.longhead.com
>
>
> [please keep replies in the newsgroup - email address unmonitored]
>
>
>

Ed,

OK - I think you'll have to use Application.OnKey then. The worksheet
object doesn't expose any type of keyboard events that you can trap.

'/ this maps Enter key to subroutine named "test"
Application.OnKey "{ENTER}", "test" '/ use {RETURN} for Return key

'/ this unmaps Enter key
Application.OnKey "{ENTER}"

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

Ed wrote:
> I actually want two different things to happen. If the user uses
> TAB, he should move to the next cell. If he hits ENTER, I want him
> to move back to the first column and activate the combobox. This is
> why I wanted to capture the ENTER.
>
>> Hi Ed,
>>
>> Ed wrote:
>>> I have some code in Worksheet_SelectionChange (ByVal Target As
>>> Range)
>>>
>>> I want to redirect the activecell to another place when the user
>>> hits ENTER (actually would like it to move the focus to my
>>> combobox).
>>>
>>> I am not able (or don't understand) how to accomplish this. I have
>>> tried the Target = 13 in other places in my code with comboboxes and
>>> keydown and it works, but it doesn't work in this sub. Any
>>> suggestions?
>>
>> The SelectionChange event will fire when the user's selection
>> changes from one cell or range to another. The Target argument is a
>> Range object that references the newly-selected range. So I don't
>> think you need to trap the Enter key - I think you could just trap
>> the event and move to your ComboBox based on the new selection.
>>
>> --
>> Regards,
>>
>> Jake Marx
>> www.longhead.com
>>
>>
>> [please keep replies in the newsgroup - email address unmonitored]