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

Thanks Jim. I didnt think so, but needed an experts input. After much
thought I changed these boxes to validation Lists instead. So I appreciate
your input.

"Jim Rech" wrote:

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