Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
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
Cell Navigation LaDonna Excel Discussion (Misc queries) 2 March 25th 10 07:14 PM
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
navigation to a previous cell on other tab? navigation to a prev. cell another tab Excel Worksheet Functions 1 June 6th 08 04:32 PM
Combobox to set value in cell on worksheet default105 Excel Discussion (Misc queries) 1 March 4th 06 10:44 PM
Combobox Affix to Cell D.Parker Excel Discussion (Misc queries) 2 April 20th 05 03:55 PM


All times are GMT +1. The time now is 08:26 AM.

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

About Us

"It's about Microsoft Excel"