View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aleksander Sliwinski Aleksander Sliwinski is offline
external usenet poster
 
Posts: 1
Default 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