How i can exit from compo box after select ?

[omek07]

Hello,

I am new in the forum and in the excel vba code

I would like to ask if anyone knows how to exit from the compobox menu after we select something (after we click to the item that we want from the dropdown menu)

Please Login or Register  to view this content.

I found this code and it worked very good but now i want when i select something to close the dropdown menu without press any button or click to another cell.

I add this to my code, its working when i select something but when i press a letter to find something from my list it crush the excel

Private Sub TempCombo_Change()

ActiveCell.Select

End Sub

Is anyone that can help me with this

Thank you very much in advanced

[jaslake]

Hi omek07

Welcome to the Forum!!!

Please wrap any Code you post in Code Tags...a Forum requirement.

You can try this...

Please Login or Register  to view this content.

Get rid of this Code...it's most likely what's causing the crash...

Please Login or Register  to view this content.

[omek07]

Thank you very much my friend

[omek07]

Hi omek07

Welcome to the Forum!!!

Please wrap any Code you post in Code Tags...a Forum requirement.

You can try this...

Please Login or Register  to view this content.

Get rid of this Code...it's most likely what's causing the crash...

Please Login or Register  to view this content.

Thank you very much my friend

I have the same problem and with this command

I dont understand why !!!

i found that if i disable Match entry from the compobox properties i dont have crush but i need the autocomplete because my list is big


oooooo i FORGOT TO mention that it gives me the crush when i am starting typing something. If i click something from the list is fine


Here is my properties for the tempcombo

TEMPCOMPO PROPERTIES.jpg

[jaslake]

Hi omek07

I'd guess you've not done this...

Get rid of this Code...it's most likely what's causing the crash...

Please Login or Register  to view this content.

If you can't sort it out...

Please attach a sample workbook the Structure of which is the same as your actual workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[omek07]

Hello again my friend,

Yes of course i replace it with the code that you gave me .


Here is a sample from me worksheet

[jaslake]

Hi omek07

I'll look at it...not tonight...this weekend.

[omek07]

Thank you very much

My lists is in the Equipment sheet. The A column is my Big list , the B column is the Descriptions , the C, D, E columns is for the Unused items (i used some formulas so i can have the Unused items and with this way the user cant select the same item again). the E column (unused2 list) is the Column that i use for the Data Validation and for the Tempcombo.

My main Sheet is the Daily_Dispatch sheet . The Validation data and the Tempcombo is in the A column under of the Equip.

You can open the tempcombo with double click

if you select a list item with mouse click is fine but if you try to type something (lets say SC008) its gonna crush the Excel.

If you erase this

Private Sub TempCombo_Click()
ActiveCell.Offset(0, 1).Activate
End Sub

You will not have the crush BUT if you select something from the drop down menu it highlightgs the next item from the list (which is a little bit confusing) but if after you select the item and press ENTER it gonna give you the correct ITEM.

[omek07]

Hi omek07

I'll look at it...not tonight...this weekend.

Hello my friend

Have you looked anything yet ???
Its just a question i dont want to push you

Thank you

[jaslake]

Hi omek07

Sorry...got tied up with Tax Returns this weekend and my deceased Sister's Estate today...been a bit busy. I'll try to look at this tomorrow.

[omek07]

It's ok my friend no problem . Whenever you have time .

Thank you

[jaslake]

Hi omek07

I've looked at it and am unable to sort it out...sorry.

[omek07]

Hi omek07

I've looked at it and am unable to sort it out...sorry.

Thank you my friend