Combo Box

  • Thread starter Thread starter RickyW
  • Start date Start date
R

RickyW

I am creating a form for a number of users and want to
give them a drop down box which they can select
information from. This is straight forward but I would
like to be able to select the data without using the mouse
to increase effeciency so the problems are. . . .
Using the Validation option doesn't autocomplete so you
have to fill in the full entry.
The Form list of combo box options work perfectly but you
have to select it with the mouse before it is activated
and you can't get out of it without using the mouse.
And normal autocomplete includes all the entries that are
in the column, it doesn't let you select where it can
autocomplet from.
I hope this makes sense and if anyone can help it is, as
always much appreciated.

RW
 
Without mouse it is a little bit more complicated.
Suppose to use validation with the list option.

Opening the box can be done with ALT arrow-Down.
Walking up and down with the up and down arrow.
ENTER to select.

It may be smart to type somewhere the list, give it a range name and
use =range inside the validation.

If you use different types of boxes in principle the same procedure
would work.

Still problems?
Mail me. Good luck!
 
Back
Top