I have a searchable ComboBox (original VBA came from https://trumpexcel.com/excel-d…-with-search-suggestions/) for the customer name. The problem I'm having is, after the ComboBox is filled. The ComboBox continues to reactivate anytime change is made to any other cell on the worksheet and also seems to stay active when the workbook is closed.
I have attached a copy of the worksheet and unprotected it so everything is visible.
Any help on this would be greatly appreciated.
I cannot open the attached file.
Sorry about that, not sure what went wrong. THe original file is an .xltm but can not upload that file extension so I saved it as an .xlsm. It opened up for me on my end please let me know if this file does the same, Also, I appreciate you taking a look.
This saveas line makes no sense.
53 is a the file format to save as a template file (xltm) . You don't want to save as a template. I would think you should save as an xlsx file which would remove any code. You don't need to add the file extension.
royUK, Thank you that does stop the re-activation on the DropDownList. However I noticed the when I type the name of the customer the DropDownList does not show matches of what is typed. Is there anyway to correct that? If not its not a big deal the user can type a few letters and then click on the arrow and get the same result. Also, Thank you for the correction on the SaveAs, I will make those changes. I really do appreciate the help on this. tjamestx
It doesn't seem to be reactivating once a selection has been made
Let me re-phase my last question to clarify. If I comment out the "'Me.ComboBox1.DropDown" the list does not reactivate once the selection is made. I'm good with that, what I was pointing out is that before the fix was implemented (commenting out the 'Me.ComboBox1.DropDown) the list would DropDown and show matches with what was being entered by the user, as the user was typing. After the fix you have to use the mouse to click on the list before seeing anything in the DropDownList. If that makes any sense??? At the same time I'm good with that if there is no fix for it. Thank you.
I don't think there is anything to use instead of that. I can't really see why it was re-activating.
OK thank you again for the help on this, I really appreciate it.
I haven't tested this because I don't have a completed sheet, but try it and let me know if it works.
Don’t have an account yet? Register yourself now and be a part of our community!
