Thread: focus
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default focus

How do I allow the user to tab (or bring to focus) the comboboxes?

Using the mouse is the only way. Controls on worksheets cannot be tabbed
to. If using a mouse is an issue for some reason you might switch to a
Data, Validation list. You can pick an item in these from the keyboard by
using Alt-Down Arrow to open the list.

--
Jim
"Capp" wrote in message
...
|I have setup a data entry form on a worksheet. I have a series of unlocked
| cells and comboboxes. How do I allow the user to tab (or bring to focus)
the
| comboboxes? Right now the user can only tab through unlocked cells. THis
is
| a form I am distributing through email so I cannot use macros...security
| issues. How do I correct this?
|
| Thanks