Need VBA validate 3 active textboxs result shown below of range column

[johnlara]

Dear experts

I have data set which is for validation of error on both sheet build A and B, i need vba code to list validation so minimize by pick unique values Page,Testcase,Testid
i want shown values of testid once done unique validation of textbox3 from both sheet A and B

for e.g
"if i select page = ASIA In Listbox1 then listbox2 show all unique values towards ASIA, then
if i select testcase= CHINA in Listbox2 then Llistbox3 show all unique values towards china
in listbox3 show all testid ,then what Tet ID select in , result should pop up in both side Build A and Build B data range from sheetBuild A and Build B
A result start at range A19
B result start at range L19


Listbox1 Unique column of B:B
Listbox2 Unique column of C:C
Listbox3 Unique column of A:A depends upon TestID , Result values will be shown in data range of BUILD A AND BUILD B of BUILD A and BUILD B SHEET'S becoz Test id reflect in both sheet

Thanks and regards

find the attachment u understand what i actual looking for

[JohnTopley]

https://www.excelforum.com/excel-pro...ox-values.html

Remarkable co-incidence!

Same question but different (????) User!!!

[johnlara]

Yes mate he is my fiend of buddy i used his data for my requirement with his knowledge also my result in Active X control form into excel range
does it cross level posting against forum rules if its so i close this action

please help on this

thanks

[JohnTopley]

I don't know if it is against the rules BUT it does mean a re-work if the original (or other) respondents reply which could have been avoided if the actual requirement i.e this post, had been used. Not least, the requirement for a userform appears to have gone.

Remember, respondents give their time for free.

UPDATE: Pleae add sample of expected results.

[johnlara]

Hi experts sorry for confusion of updating across scenarios requirements as matching with other threads,
i just used his data

i have enclosed my requirement file

[JohnTopley]

Please Login or Register  to view this content.

I see no advantage in using Controls rather than simple Data Validation dropdowns.

And ideally get rid of merged cells