#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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get focus back on an Excel file? Stumpiana Charts and Charting in Excel 1 November 18th 05 01:21 AM
tool tip to open when the cell has the focus GRIFFO Excel Worksheet Functions 6 May 19th 05 07:04 PM
Focus David Unger Excel Worksheet Functions 20 March 21st 05 06:43 PM
Cursor Keys does not change cell focus Skypilot Excel Discussion (Misc queries) 3 February 24th 05 07:13 AM
Printing switches focus off proper sheet Abi Excel Worksheet Functions 1 January 26th 05 07:42 PM


All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"