Transfer Combobox value to worksheet with Enter key.

[ImranBhatti]

Greetings to all forum

I have an ActiveX ComboBox control on sheet1.after reaching the required item in the dropdown list I want to transfer the item to say Cell B2 with enter key.But the event procedure list does not contain the EnterKeypress event

How can I use the enter key to send the selected item in the dropdown list of combobox to worksheet?

Best Regards
Imran Bhatti

[Logit]

.
Modify this code:

Please Login or Register  to view this content.

Further explanation in this resource: http://www.contextures.com/xlDataVal10.html