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