Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox to cell navigation
Is this possible?
I have designed several combo boxes into a spreadsheet where info is also entered into unprogrammed cells. I would like to be able to navigate from a combo box to a cell without using the mouse. (Tab does not work at all.) Any program/setting information regarding this would be great! Thanks, Suzanne |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox to cell navigation
This is because the combobox retains the "focus" (remains selected) and
can give rise to all sorts of problems. When using worksheet controls/textboxes etc. I usually include something like :- ActiveSheet.Range("A1").Select in my code which ensures that focus is returned to the worksheet and things work as normal. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Navigation | Excel Discussion (Misc queries) | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
navigation to a previous cell on other tab? | Excel Worksheet Functions | |||
Combobox to set value in cell on worksheet | Excel Discussion (Misc queries) | |||
Combobox Affix to Cell | Excel Discussion (Misc queries) |