ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change of behavior in Combo Box (https://www.excelbanter.com/excel-discussion-misc-queries/188746-change-behavior-combo-box.html)

Learning Excel

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.


All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com