PDA

View Full Version : Userform With Multiple Independent Combobox (delete row when not match)



epoiezam
02-17-2016, 01:14 AM
Hi

Using Userform Multiple Combobox
Can someone show me.. How to get vba to delete all rows that do not match combobox value.

Sample : If Combobox Value equal to:-
Combobox1 = "Blank"
Combobox2 = Male
Combobox3 = Teacher

Result:-
John_____Male____Teacher
Gerard___Male____Lawyer (this row will be deleted)
Russell___Male____Teacher
Jenny____Female__Teacher (this row will be deleted)

Thanks Guys..

mancubus
02-17-2016, 08:58 AM
epoizam

i am not sure the result table you posted demonstrates the correct output.

post a sample workbook (Go Advanced, Manage Attachments, Add Files, Select Files, select a file, Open, Upload Files, Done) by marking the rows which will be deleted based on combobox values.