getting input from four combo boxes in one user form and not posting duplicates.
Posted on 2009-04-26
combo box 1 takes input from row a which is make of car
combo box 2 takes input from row b which is year of car fom 1980 and up
combo box 3 takes input from row c which model of car
combo box takes input from row d which is engine size
it takes it from C:\Users\Owner\Desktop\Real Indy\Filter.xlsx and post it in row A cell 1,2,3,4 repsectively in C:\Users\Owner\Desktop\Real Indy\Sheet1.xlsx. i have each make written at least 150 times so Acura comes first and it says Acura 150 times in clomn A then Integra is repeated several times since it was made for many years and same problem with engine sizes so they repeat in the combo boxes. How do i stop that? and then when the user chooses 99 acura Cl w/ the 2.3L engine in Colum E i have the oil filter number and would like to take that input from row E Filter.xlsx and paste in in A5 Sheet1. i have very little knowledge of macros so if the whole macro is written that would be great.