Combobox search dropdown triggering when editing other sheets

[Greenbehindthecells]

Good afternoon,

I hope everyone is having a great afternoon. My combobox triggers when editing other cells in other sheets. This has been happening during the course of making this sheet, way before I asked and received code help. I am not sure how to resolve this. I will have members of my team enter data on a sheet in this workbook for corrections. If the combobox could only trigger when text is entered in the combobox, it would save a lot of headaches. Any assistance or guidance would be appreciated. I hope you have a wonderful day.





Combobox behavior normal:

Combobox triggering (and making itself visible) when editing cells in other sheets.

Ufiltering data in my data sheet also has this same result, the combobox search from Pratice Details V2 pops up.

File Structure:
List (where my dropdown formula is) :

Combobox.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Response			Pratices	Searchable
2	Yes			ABC	BBC	Not found
3	No			ABC PEDS	BBC CARD
4	Unkown			ABC GI	BBC GI
5				ABC CARD	BBC NEPH
6				ABC NEPH	BBC PEDS
7				BBC
8				BBC PEDS
9				BBC GI
10	PCPPaps			BBC CARD
11	Yes			BBC NEPH
12	No			CBC
13	Unkown			CBC PEDS
14	Specific Provider Only			CBC GI
15				CBC CARD
16				CBC NEPH
17				DBC
18				DBC PEDS
19				DBC GI
20				DBC CARD
21				DBC NEPH
22
23
24
25
List

Cell Formulas
Range	Formula
E2:E6	E2	=SORT(FILTER(Practices6[#Data],ISNUMBER(SEARCH('Practice Details V2'!$D$2,Practices6[#Data])),"Not found"))
F2	F2	=SORT(FILTER(Practices6[#Data],ISTEXT(SEARCH('Practice Details V2'!$D$2,Practices6[#Data])),"Not found"))
Dynamic array formulas.

Practice Details V2 (where combobox is) cell D2:

Combobox.xlsm
	A	B	C	D	E	F			I	J			M	N	O	P	Q	R	S	T	U	V
1										Contact				Hours
2				BBC						formula from other sheet				Not on file
3
4
5
6		Tax	NPI	Prov		Addresses			City	State			Phone	Fax
7		888888888	9999999994	WILLIAMS, MICHAEL, MD		11 BROADWAY, STE 1			WILMINGTON	DE			1100000001	9999999930		County Health Dept
8			9999999974	LEWIS, BENJAMIN, MD												formula from other sheet
9			9999999954	PHILLIPS, SOPHIA, DO
10			9999999934	MYERS, CHLOE, MD
11
12
13
14																Misc Notes
15																formula from other sheet
16
17
18
19																P?	POC?
20																formula from other sheet	formula from other sheet
21
22
23
24																Languages		Acron
25																Not on File		EE
26
27
Practice Details V2

Cell Formulas
Range	Formula
N2	N2	=IFERROR(INDEX(NewPract[#Data],MATCH($D$2,NewPract[GROUP NAME],0),15)," ")
B7	B7	=IFERROR(FILTER(UNIQUE(IF(FILTER(NewPract[TAX ID (TAB REPORT)],EXACT(NewPract[GROUP NAME],$D$2))=0,"No Data",FILTER(NewPract[TAX ID (TAB REPORT)],EXACT(NewPract[GROUP NAME],$D$2)))),UNIQUE(IF(FILTER(NewPract[TAX ID (TAB REPORT)],EXACT(NewPract[GROUP NAME],$D$2))=0,"No Data",FILTER(NewPract[TAX ID (TAB REPORT)],EXACT(NewPract[GROUP NAME],$D$2))))<>""),"make a selection")
C7:D10	C7	=IFERROR(UNIQUE(IF(FILTER(NewPract[NPI],EXACT(NewPract[GROUP NAME],$D$2))=0,"no data available",FILTER(NewPract[[NPI]:[PRINT NAME]],EXACT(NewPract[GROUP NAME],$D$2)))),"make selection in field")
F7:N7	F7	=IFERROR(UNIQUE(IF(FILTER(NewPract[ADDRESS3],EXACT(NewPract[GROUP NAME],$D$2))=0,"No data avialable",FILTER(NewPract[[ADDRESS3]:[FAX (TAB REP MATCH)]],EXACT(NewPract[GROUP NAME],$D$2)))),"make selection in field")
P25	P25	=FILTER(IFERROR(UNIQUE(IF(FILTER(NewPract[LANG CONSOL],EXACT(NewPract[GROUP NAME],$D$2))=0,"not on file",FILTER(NewPract[LANG CONSOL],EXACT(NewPract[GROUP NAME],$D$2)))),"make Selection in field"),IFERROR(UNIQUE(IF(FILTER(NewPract[LANG CONSOL],EXACT(NewPract[GROUP NAME],$D$2))=0,"not on file",FILTER(NewPract[LANG CONSOL],EXACT(NewPract[GROUP NAME],$D$2)))),"make Selection in field")<>"")
R25	R25	=IFERROR(UNIQUE(IF(FILTER(NewPract[LOB],EXACT(NewPract[GROUP NAME],$D$2))=0,"No data availabe",FILTER(NewPract[LOB],EXACT(NewPract[GROUP NAME],$D$2)))),"Make selection field")
Dynamic array formulas.

DD SS NN FF Main (where data is)

Combobox.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	GROUP NAME	TAX ID (TAB REPORT)	NPI	PRINT NAME	ADDRESS3	ADDRESS1	ADDRESS2	CITY	STATE	ZIP	COUNTY	PHONE	FAX (TAB REP MATCH)	LANG CONSOL	HOURS CONSOL
2	ABC	999999999	9999999999	NIEVES, JESUS, DO	11 BROADWAY, STE 11	11 BROADWAY	STE 11	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9991	(999) 999-9992	GREEK, MANDARIN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
3	ABC	999999999	9999999979	GARCIA, NANCY, DO	11 BROADWAY, STE 11	11 BROADWAY	STE 11	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9991	(999) 999-9992	Not on File	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
4	ABC	999999999	9999999959	RIVERA, ALEXANDER, MD	11 BROADWAY, STE 11	11 BROADWAY	STE 11	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9991	(999) 999-9992	GREEK, MANDARIN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
5	ABC	999999999	9999999939	COOPER, NATHAN, MD	11 BROADWAY, STE 11	11 BROADWAY	STE 11	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9991	(999) 999-9992	POLISH, PORTEGUESE	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
6	ABC CARD	999999999	9999999996	SHIN, XE, DO	10 BROADWAY, STE 22	10 BROADWAY	STE 22	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9997	(999) 999-9998	RUSSIAN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
7	ABC CARD	999999999	9999999976	CLARK, EDWARD, MD	10 BROADWAY, STE 22	10 BROADWAY	STE 22	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9997	(999) 999-9998	DUTCH	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
8	ABC CARD	999999999	9999999956	ROBERTS, ALEXIS, MD	10 BROADWAY, STE 22	10 BROADWAY	STE 22	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9997	(999) 999-9998	RUSSIAN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
9	ABC CARD	999999999	9999999936	GRIFFIN, AVERY, DO	10 BROADWAY, STE 22	10 BROADWAY	STE 22	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9997	(999) 999-9998	DUTCH	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
10	ABC GI	999999999	9999999997	CARTER, CARTER, DO	10 BROADWAY, STE 11	10 BROADWAY	STE 11	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9995	(999) 999-9996	SPANISH	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
11	ABC GI	999999999	9999999977	ROBINSON, DONNA, MD	10 BROADWAY, STE 11	10 BROADWAY	STE 11	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9995	(999) 999-9996	HAITIAN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
12	ABC GI	999999999	9999999957	PEREZ, ANTHONY, DO	10 BROADWAY, STE 11	10 BROADWAY	STE 11	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9995	(999) 999-9996	SPANISH	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
13	ABC GI	999999999	9999999937	COX, LUCAS, MD	10 BROADWAY, STE 11	10 BROADWAY	STE 11	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9995	(999) 999-9996	HAITIAN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
14	ABC NEPH	999999999	9999999995	OHNSON, LISA, DO	9 BROADWAY, STE 1	9 BROADWAY	STE 1	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9999	(999) 999-9910	POLISH, PORTEGUESE	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: CLOSED, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
15	ABC NEPH	999999999	9999999975	RODRIGUEZ, AMY, DO	9 BROADWAY, STE 1	9 BROADWAY	STE 1	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9999	(999) 999-9910	GREEK, MANDARIN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: CLOSED, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
16	ABC NEPH	999999999	9999999955	TURNER, JOSEPH, MD	9 BROADWAY, STE 1	9 BROADWAY	STE 1	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9999	(999) 999-9910	POLISH, PORTEGUESE	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: CLOSED, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
17	ABC NEPH	999999999	9999999935	HAYES, ZACHARY, MD	9 BROADWAY, STE 1	9 BROADWAY	STE 1	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9999	(999) 999-9910	GREEK, MANDARIN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: CLOSED, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
18	ABC PEDS	999999999	9999999998	SMITH, JOHN, DO	11 BROADWAY, STE 22	11 BROADWAY	STE 22	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9993	(999) 999-9994	Not on File	Not on file
19	ABC PEDS	999999999	9999999978	MARTINEZ, KEVIN, MD	11 BROADWAY, STE 22	11 BROADWAY	STE 22	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9993	(999) 999-9994	TELUGO	Not on file
20	ABC PEDS	999999999	9999999958	MITCHELL, OLIVIA, MD	11 BROADWAY, STE 22	11 BROADWAY	STE 22	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9993	(999) 999-9994	Not on File	Not on file
21	ABC PEDS	999999999	9999999938	RICHARDSON, JASMINE, DO	11 BROADWAY, STE 22	11 BROADWAY	STE 22	WILMINGTON	DE	19801	NEW CASTLE (F)	(999) 999-9993	(999) 999-9994	TELUGO	Not on file
22	BBC	888888888	9999999994	WILLIAMS, MICHAEL, MD	11 BROADWAY, STE 1	11 BROADWAY	STE 1	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0001	(999) 999-9930	Not on File	Not on file
23	BBC	888888888	9999999974	LEWIS, BENJAMIN, MD	11 BROADWAY, STE 1	11 BROADWAY	STE 1	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0001	(999) 999-9930	Not on File	Not on file
24	BBC	888888888	9999999954	PHILLIPS, SOPHIA, DO	11 BROADWAY, STE 1	11 BROADWAY	STE 1	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0001	(999) 999-9930	Not on File	Not on file
25	BBC	888888888	9999999934	MYERS, CHLOE, MD	11 BROADWAY, STE 1	11 BROADWAY	STE 1	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0001	(999) 999-9930	Not on File	Not on file
26	BBC CARD	888888888	9999999991	DAVIS, MARY, DO	10 BROADWAY, STE 4	10 BROADWAY	STE 4	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0004	(999) 999-9882	GREEK, MANDARIN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
27	BBC CARD	888888888	9999999971	HALL, RICHARD, MD	10 BROADWAY, STE 4	10 BROADWAY	STE 4	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0004	(999) 999-9882	POLISH, PORTEGUESE	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
28	BBC CARD	888888888	9999999951	EVANS, JACK, MD	10 BROADWAY, STE 4	10 BROADWAY	STE 4	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0004	(999) 999-9882	GREEK, MANDARIN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
29	BBC CARD	888888888	9999999931	GRAHAM, ADAM, MD	10 BROADWAY, STE 4	10 BROADWAY	STE 4	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0004	(999) 999-9882	POLISH, PORTEGUESE	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
30	BBC GI	888888888	9999999992	BROWN, ROBERT, MD	10 BROADWAY, STE 3	10 BROADWAY	STE 3	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0003	(999) 999-9898	DUTCH	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
31	BBC GI	888888888	9999999972	WALKER, ANNA, DO	10 BROADWAY, STE 3	10 BROADWAY	STE 3	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0003	(999) 999-9898	RUSSIAN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
32	BBC GI	888888888	9999999952	PARKER, MIA, DO	10 BROADWAY, STE 3	10 BROADWAY	STE 3	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0003	(999) 999-9898	DUTCH	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
33	BBC GI	888888888	9999999932	HAMILTON, ARIA, MD	10 BROADWAY, STE 3	10 BROADWAY	STE 3	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0003	(999) 999-9898	RUSSIAN	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: 8:00AM TO 5PM, FRI: 8:00AM TO 5PM, SAT: CLOSED, SUN: CLOSED
34	BBC NEPH	888888888	9999999990	MILLER, JAMES, MD	9 BROADWAY, STE 5	9 BROADWAY	STE 5	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0005	(999) 999-9866	Not on File	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: CLOSED, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
35	BBC NEPH	888888888	9999999970	ALLEN, LINDSEY, DO	9 BROADWAY, STE 5	9 BROADWAY	STE 5	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0005	(999) 999-9866	TELUGO	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: CLOSED, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
36	BBC NEPH	888888888	9999999950	EDWARDS, ISABELLA, MD	9 BROADWAY, STE 5	9 BROADWAY	STE 5	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0005	(999) 999-9866	Not on File	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: CLOSED, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
37	BBC NEPH	888888888	9999999930	SULLIVAN, HARPER, DO	9 BROADWAY, STE 5	9 BROADWAY	STE 5	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0005	(999) 999-9866	TELUGO	MON: 8:00AM TO 5PM, TUES: 8:00AM TO 5PM, WED: 8:00AM TO 5PM, THURS: CLOSED, FRI: 8:00AM TO 5PM, SAT: 8:00AM TO 5PM, SUN: CLOSED
38	BBC PEDS	888888888	9999999993	JONES, SARAH, DO	11 BROADWAY, STE 2	11 BROADWAY	STE 2	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0002	(999) 999-9914	HAITIAN	Not on file
39	BBC PEDS	888888888	9999999973	LEE, KAREN, MD	11 BROADWAY, STE 2	11 BROADWAY	STE 2	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0002	(999) 999-9914	SPANISH	Not on file
40	BBC PEDS	888888888	9999999953	CAMPBELL, SAMUEL, MD	11 BROADWAY, STE 2	11 BROADWAY	STE 2	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0002	(999) 999-9914	HAITIAN	Not on file
41	BBC PEDS	888888888	9999999933	FORD, WYATT, DO	11 BROADWAY, STE 2	11 BROADWAY	STE 2	WILMINGTON	DE	19801	NEW CASTLE (F)	(110) 000-0002	(999) 999-9914	SPANISH	Not on file
DD SS NN FF Main

Cell Formulas
Range	Formula
N2:N41	N2	=IF(AND([@LANG1]=0,[@LANG2]=0,[@LANG3]=0,[@LANG4]=0,[@LANG5]=0,[@LANG6]=0),"Not on File",TEXTJOIN(", ",TRUE,NewPract[@[LANG1]:[LANG6]]))
O2:O41	O2	=IF(AND( [@MON]=0,[@TUE]=0,[@WED]=0,[@THUR]=0,[@FRI]=0,[@SAT]=0,[@SUN]=0), "Not on file",TEXTJOIN(", ",TRUE,"MON: "&[@MON], "TUES: "&[@TUE],"WED: "&[@WED],"THURS: "&[@THUR],"FRI: "&[@FRI],"SAT: "&[@SAT], "SUN: "&[@SUN]))
E2:E41	E2	=TEXTJOIN(", ",TRUE,[@ADDRESS1],[@ADDRESS2])

Code:

Private Sub Tempbox2_Change()
Tempbox2.ListFillRange = "Dropdown1"
Me.Tempbox2.DropDown
End Sub

Private Sub Tempbox4_Change()
Tempbox4.ListFillRange = "Dropdown1"
Me.Tempbox4.DropDown
End Sub
Private Sub Tempbox4_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
With Tempbox4
Select Case KeyCode
Case 13 'ENTER
If .ListIndex > -1 Then
Range("D2") = .Value 'send combobox value to cell D2 'adjust the cell reference
Else
MsgBox "Found nothing"
End If

End Select
End With
End Sub

 

[Akuini]

My combobox triggers when editing other cells in other sheets.

That's because you are using Linked cell, it must be empty.

Try replacing all your code above with this:

Private Sub Tempbox4_Change()
With Tempbox4
    If .ListCount = 0 Then
        .List = Range("Dropdown1").Value
    End If
End With
Me.Tempbox4.DropDown
End Sub

Private Sub Tempbox4_GotFocus()
With Tempbox4
    .LinkedCell = Empty
    .ListFillRange = Empty
    .List = Range("Dropdown1").Value
End With
End Sub

Private Sub Tempbox4_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
With Tempbox4
    Select Case KeyCode
    Case 13 'ENTER
        If .ListIndex > -1 Then
          Range("D2") = .Value 'send combobox value to cell D2 'adjust the cell reference
        Else
          MsgBox "Found nothing"
        End If
    End Select
End With
End Sub

Note: After you pick an item in the combobox, you need to press Enter to send combobox value to cell D2

 

[Greenbehindthecells]

That's because you are using Linked cell, it must be empty.

Try replacing all your code above with this:

Private Sub Tempbox4_Change()
With Tempbox4
    If .ListCount = 0 Then
        .List = Range("Dropdown1").Value
    End If
End With
Me.Tempbox4.DropDown
End Sub

Private Sub Tempbox4_GotFocus()
With Tempbox4
    .LinkedCell = Empty
    .ListFillRange = Empty
    .List = Range("Dropdown1").Value
End With
End Sub

Private Sub Tempbox4_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
With Tempbox4
    Select Case KeyCode
    Case 13 'ENTER
        If .ListIndex > -1 Then
          Range("D2") = .Value 'send combobox value to cell D2 'adjust the cell reference
        Else
          MsgBox "Found nothing"
        End If
    End Select
End With
End Sub

Note: After you pick an item in the combobox, you need to press Enter to send combobox value to cell D2

Good morning,

Thank you. I replaced all the code with this code and received a runtime error.

 

[Akuini]

Sorry, I tested it with the "Dropdown1" was on the same sheet as the combobox.
Try this:
In VBA editor, in property window, in Tempbox4 property, you need to clear: LinkedCell & ListFillRange.
Then replace the previous code with this:

Private Sub Tempbox4_Change()
With Tempbox4
    If .ListCount = 0 Then
        .List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit
    End If
End With
Me.Tempbox4.DropDown
End Sub

Private Sub Tempbox4_GotFocus()
With Tempbox4
    .List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit
End With
End Sub

Private Sub Tempbox4_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
With Tempbox4
    Select Case KeyCode
    Case 13 'ENTER
        If .ListIndex > -1 Then
          Range("D2") = .Value 'send combobox value to cell D2 'adjust the cell reference
        Else
          MsgBox "Found nothing"
        End If
    End Select
End With
End Sub

You need to adjust the code in this part:

.List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit

change sheet reference to where the named range "Dropdown1" is located.

 

[Greenbehindthecells]

Sorry, I tested it with the "Dropdown1" was on the same sheet as the combobox.
Try this:
In VBA editor, in property window, in Tempbox4 property, you need to clear: LinkedCell & ListFillRange.
Then replace the previous code with this:

Private Sub Tempbox4_Change()
With Tempbox4
    If .ListCount = 0 Then
        .List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit
    End If
End With
Me.Tempbox4.DropDown
End Sub

Private Sub Tempbox4_GotFocus()
With Tempbox4
    .List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit
End With
End Sub

Private Sub Tempbox4_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
With Tempbox4
    Select Case KeyCode
    Case 13 'ENTER
        If .ListIndex > -1 Then
          Range("D2") = .Value 'send combobox value to cell D2 'adjust the cell reference
        Else
          MsgBox "Found nothing"
        End If
    End Select
End With
End Sub

You need to adjust the code in this part:

.List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit

change sheet reference to where the named range "Dropdown1" is located.

I removed the linked cell and list fill range from the properties of the combobox, saved and then moved to VBA to past the code and change the name 'sheet2' to 'List'. Should it be in Keydown? There are other options. I recieved another runtime error so I thought this was my mistake, not using the correct option here, Thank you very much.

 

[Greenbehindthecells]

Sorry, I tested it with the "Dropdown1" was on the same sheet as the combobox.
Try this:
In VBA editor, in property window, in Tempbox4 property, you need to clear: LinkedCell & ListFillRange.
Then replace the previous code with this:

Private Sub Tempbox4_Change()
With Tempbox4
    If .ListCount = 0 Then
        .List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit
    End If
End With
Me.Tempbox4.DropDown
End Sub

Private Sub Tempbox4_GotFocus()
With Tempbox4
    .List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit
End With
End Sub

Private Sub Tempbox4_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
With Tempbox4
    Select Case KeyCode
    Case 13 'ENTER
        If .ListIndex > -1 Then
          Range("D2") = .Value 'send combobox value to cell D2 'adjust the cell reference
        Else
          MsgBox "Found nothing"
        End If
    End Select
End With
End Sub

You need to adjust the code in this part:

.List = Sheets("Sheet2").Range("Dropdown1").Value 'change sheet reference to suit

change sheet reference to where the named range "Dropdown1" is located.

This is the error. My 'List' sheet is were the named range 'Dropdown1' is.

 

[Akuini]

Could you please upload a sample workbook (without sensitive data) to a file-sharing site like Dropbox.com or Google Drive, and then share the link here? Also, ensure that the link is accessible to anyone.

 

[Greenbehindthecells]

Could you please upload a sample workbook (without sensitive data) to a file-sharing site like Dropbox.com or Google Drive, and then share the link here? Also, ensure that the link is accessible to anyone.

Thank you. I am so sorry I don't know what I am doing wrong. This is my sheet with made up data. The proprietary sheet has the same issue.

Combobox.xlsm

Microsoft Excel Workbook

1drv.ms

 

[Akuini]

Ok, replace all previous code with this one:

Private nFlag As Boolean
Private Ary
Private Sub Tempbox4_Change()
    If nFlag = False Then
        Range("d2") = Tempbox4.Value
        Call change_list
        Me.Tempbox4.DropDown
    End If
End Sub

Private Sub Tempbox4_GotFocus()

    Range("d2") = Tempbox4.Value
    Call change_list

End Sub

Sub change_list()
With Tempbox4
    Ary = Sheets("List").Range("Dropdown1").Value
            If Not IsArray(Ary) Then Ary = Array(Ary)
    .List = Ary
End With

End Sub


Private Sub Tempbox4_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
nFlag = False
With Tempbox4
    Select Case KeyCode
        Case vbKeyDown, vbKeyUp
                nFlag = True 'don't change the list if an item is selected via up-down arrow
    
        Case 13 'ENTER
            If .ListIndex > -1 Then
              Range("D2") = .Value 'send combobox value to cell D2 'adjust the cell reference
            Else
              MsgBox "Found nothing"
            End If
    End Select
End With
End Sub

 

[Greenbehindthecells]

Ok, replace all previous code with this one:

Private nFlag As Boolean
Private Ary
Private Sub Tempbox4_Change()
    If nFlag = False Then
        Range("d2") = Tempbox4.Value
        Call change_list
        Me.Tempbox4.DropDown
    End If
End Sub

Private Sub Tempbox4_GotFocus()

    Range("d2") = Tempbox4.Value
    Call change_list

End Sub

Sub change_list()
With Tempbox4
    Ary = Sheets("List").Range("Dropdown1").Value
            If Not IsArray(Ary) Then Ary = Array(Ary)
    .List = Ary
End With

End Sub


Private Sub Tempbox4_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
nFlag = False
With Tempbox4
    Select Case KeyCode
        Case vbKeyDown, vbKeyUp
                nFlag = True 'don't change the list if an item is selected via up-down arrow
   
        Case 13 'ENTER
            If .ListIndex > -1 Then
              Range("D2") = .Value 'send combobox value to cell D2 'adjust the cell reference
            Else
              MsgBox "Found nothing"
            End If
    End Select
End With
End Sub

Thank you for all your help! I don't see it traveling for attention to other sheets or even this one as I make changes. I appreciate your time and expertise.