Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to call an event procedure | Excel Programming | |||
keydown event | Excel Programming | |||
Open event to call procedure ONLY on Monday | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
ComboBox Event Procedure problem | Excel Programming |