LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 98
Default Change of behavior in Combo Box

My Combo has people's name and it works as a dropdown list feeded form a cell.
Also as I change names uses vlookup to populate data already enter in
different
worksheet.
It was working well and all of the sudden today I opened it and it does this :
When I start writting, lets say names starting with letter " B " , as soon
as I
write the "B" it writes the first name on the list starting with "B", when
in fact
there are around 10 names starting with letter "B".
Then it jump to a regular cell ( by the way that's the only cell unlock, as
the
worksheet is protected and must have the link cell unprotected ).
Used to work fine as : if writting the letter "B" then I could keep writting
until
all choices are used in order for me to select the dropdown needed.
Please help, I tried everything and still has this weird behavior. Thanks
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.
 
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
Auto run maco/change behavior of save/close m schmitz Excel Discussion (Misc queries) 0 February 10th 06 04:00 AM
How do I change the default Paste behavior Adam Bell Excel Discussion (Misc queries) 3 August 20th 05 05:05 AM
How do I change the default paste behavior Adam Bell Excel Discussion (Misc queries) 0 August 18th 05 06:21 PM
Odd behavior on margin change John Charts and Charting in Excel 2 June 20th 05 02:03 PM
change tab key behavior SpecialKay Excel Worksheet Functions 2 December 6th 04 04:29 PM


All times are GMT +1. The time now is 02:23 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"