list box and text box --drop down and selection problem

[catchnanan]

Dear Friends

I have a very good excel of selecting a list of names which are already feeded in the column AM.
When i enter a first few letters in column D where i want to enter a name ,a drop down will come like GOOGLE SEARCH and we can pick up a name by just clicking on it
but the PROBLEM is if there is no name in the list which we are looking for i have to type the full name and DOUBL CLICK it so that it will sit in the cell.

Here what i want is if i type a name which is not there in the list ,instead of double clicking that name,jsimply clicking enter or tab after punching the name that particular cell should catch the name ...because double clik make it time consuming when we enter 300+ records

I have attached the list

I greatly hope some excell genius over here can surely do this and help me
Kindly help me to solve my problem sir

Narayanan

[humdingaling]

ok so i think i understand what your asking
type something into textbox1 and press Enter to trigger
it will place whatever it in textbox into last row of column D

Please Login or Register  to view this content.

[nilem]

Hi Narayanan,
Re your PM
please check the attachment

[catchnanan]

Hai humdingaling i am so much thankful to you ...it is very nice..Can u do a small change so that if i either enter "enter key" or "tab key" it can work

Thanking you
Narayanan

[catchnanan]

Hai Nilem sir now your product (the entire thing which u gave me about one year ) is so wonderful ..Not it is even more beautiful sir.
thanking you so much

[humdingaling]

in the IF loop put OR keycode = vbKeyTab as well


list of vbkeycodes
http://msdn.microsoft.com/en-au/libr...(v=vs.60).aspx

[catchnanan]

Hai Nilem sir one small request is it possible to make a few changes like
Now when we press enter key "it moves down wards"
changes may be like
1.tab or enter means going right side
2 and activating left right up down arrrow also

[nilem]

Hi Narayanan,
let's try to change a couple of lines of code
this line in Private Sub TextBox1_KeyDown(...)

Please Login or Register  to view this content.

change to

Please Login or Register  to view this content.

and this line in Private Sub Worksheet_SelectionChange(...)

Please Login or Register  to view this content.

change to this lines

Please Login or Register  to view this content.

[catchnanan]

Dear Nilem Sir

All the credits go to you sir.
thank u very much for your help