Thread: Combo Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
 
Posts: 123
Default Combo Box

When you press the arrow keys - up or down, it acually makes the
selection of the up or down element in the list.
When you scroll up and down with the mouse by clicking on the combobox
arrows, it just scrolls without changing the selection.

So now, in the properties of the combobox in question, check what value
is entered in the 'Text' field. Is the entered value the last element in
the list? If yes, then when the form is shown, the last element is
selected and if you press the down key, it will just jump to what ever
next selectable control is there, down the combobox.

So you can either enter the first element in the text field, or leave
the text field blank.

Sharad


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!