Add a combo box
I created a combo box with values from another sheet. The box and dropdown
work great. Is there a way to tab from a cell into the combo box as well as one combo box to another. When I tab now the curser goes into the cell behind the combo box. I am using Excel 2003. |
Add a combo box
I believe that this would take some VB code (macros) that would likely
require some complex logic to work exactly the way you want. Unless you had some very strict rules to govern when to do a "special" tab action, it could get pretty squirrely in the code. For instance, how do you (the code) know whether the user wants to tab from combo box #1 to combo box #2 or actually wants to do a normal tab out of the combo box to a cell on the worksheet? You might give consideration to locking cells you don't want to be entered when a [tab] is used and then protecting the sheet with the option to allow selecting locked cells cleared. "bobsuds" wrote: I created a combo box with values from another sheet. The box and dropdown work great. Is there a way to tab from a cell into the combo box as well as one combo box to another. When I tab now the curser goes into the cell behind the combo box. I am using Excel 2003. |
All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com