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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>
>
>

Thank you Rick,

I have used your suggestion and the job is done.

Greetings,
Alexander Sliwiñski


Uzytkownik "Rick Rothstein" <(E-Mail Removed)> napisal w
wiadomosci news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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
>>
>>
>>
>