LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default continued combox frustration

I have a combo box and the code ties its row sourse to a
series of cells in one of my worksheets. The selection
options are A, B, C, D etc.

I have a change event code that will change another cell
in another sheet if this box changes. If I use the drop
down list and click an option, it changes the linked
cell. If I tab through the box then tab back to it and
type in my option, the linked cell changes. However, if I
tab straight to the combo box (the text in the box
highlights by default) and simply type a new letter in it,
the change event does not trigger for some reason. When I
tab out and come back and do the same thing, it will.
Please help! I need this to work if you tab too it and
overtype the highlighted text????
 
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
Display data in a combox box Oggy Excel Discussion (Misc queries) 1 January 2nd 07 09:30 PM
how do I get combox in excel cell KJ Excel Discussion (Misc queries) 1 March 9th 06 10:29 PM
Assigning a value to a cell from a combox sjayar Excel Discussion (Misc queries) 3 November 2nd 05 12:58 PM
change cell link in combox box dynamically Kate Yang Excel Discussion (Misc queries) 2 August 30th 05 08:51 PM
Combox Locking D.Parker Excel Discussion (Misc queries) 2 April 27th 05 11:03 PM


All times are GMT +1. The time now is 03:38 AM.

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"