How can I detect a tab or carriage return in combo box

Question

How can I detect a tab or carriage return in combo box

jrice174 (Civil/Environmental)

(OP)

16 Apr 08 10:46

On a VBA user form I have some list boxes and combo boxes. As the user enters data and then hits a tab or carriage return to go to the next box I would like to sense the tab or carriage return so I can use that data immediately. Is there an event that I can use or a way to sense the carriage return?

TheTick (Mechanical) · Answer 1 · 2008-04-16 11:18:09

Perhaps use KeyUp/KeyDown/Keypress and check the ASCII code of the key. Works for textboxes.

joerd (Chemical) · Answer 2 · 2008-04-16 14:13:15

You can recognize the Enter key with the KeyPress event of the ListBox / Combobox. The Tab key will not be recognized, but it will fire the ListBox_Exit event, for example.

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

jrice174 (Civil/Environmental) · Answer 3 · 2008-04-16 14:46:33

Thanks that did it. I really appreciate how quickly I get great answers from this forum.

Come Join Us!

Posting Guidelines

How can I detect a tab or carriage return in combo box