focus
 

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

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

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