call a combobox KeyDown event from another procedure
 

I have defined a combobox keydown (cbx_KeyDown) event in my UserForm module
that works when the user presses the Enter Key.
Now, I would like to call that procedure/event (with the Enter key passed)
from within a command button click event (cmd_Click).

The problem is that the code like the following:
call cbx_KeyDown(KeyCode: = 13, Shift: = 0)

reports a syntax error.

Alternatively when I write:
Call UserForm_KeyDown(13, 0)
I receive compile error Type Mismatch.

Is there a way of making it work?

Greetings,
Alexander ¦liwiñski

call a combobox KeyDown event from another procedure
 

Event code is not really meant for you to call directly. The normal way of
handling what I think you are trying to do is to put the common code in a
subroutine (with arguments) and call it from your ComboBox KeyDown event and
from your CommandButton click event passing in the necessary arguments to
make it work the way you want.

--
Rick (MVP - Excel)


"Aleksander ¦liwiñski" wrote in message
...
I have defined a combobox keydown (cbx_KeyDown) event in my UserForm module
that works when the user presses the Enter Key.
Now, I would like to call that procedure/event (with the Enter key passed)
from within a command button click event (cmd_Click).

The problem is that the code like the following:
call cbx_KeyDown(KeyCode: = 13, Shift: = 0)

reports a syntax error.

Alternatively when I write:
Call UserForm_KeyDown(13, 0)
I receive compile error Type Mismatch.

Is there a way of making it work?

Greetings,
Alexander ¦liwiñski

call a combobox KeyDown event from another procedure
 

Thank you Rick,

I have used your suggestion and the job is done.

Greetings,
Alexander Sliwiñski


Uzytkownik "Rick Rothstein" napisal w
wiadomosci ...
Event code is not really meant for you to call directly. The normal way of
handling what I think you are trying to do is to put the common code in a
subroutine (with arguments) and call it from your ComboBox KeyDown event
and from your CommandButton click event passing in the necessary arguments
to make it work the way you want.

--
Rick (MVP - Excel)


"Aleksander ¦liwiñski" wrote in message
...
I have defined a combobox keydown (cbx_KeyDown) event in my UserForm
module that works when the user presses the Enter Key.
Now, I would like to call that procedure/event (with the Enter key
passed) from within a command button click event (cmd_Click).

The problem is that the code like the following:
call cbx_KeyDown(KeyCode: = 13, Shift: = 0)

reports a syntax error.

Alternatively when I write:
Call UserForm_KeyDown(13, 0)
I receive compile error Type Mismatch.

Is there a way of making it work?

Greetings,
Alexander ¦liwiñski