How do i avoid repetitive codes when i have a userform with many varying options?

For example i have this userform with 3 comboboxes.

let them be combobox_dpfs_system, combobox_dpfs_af, combobox_dpfs_accessory.

combobox_dpfs_system has 2 choices: "System 1" or "System 2"
combobox_dpfs_af has 4 choices: "100 AF", "200 AF", "300 AF", "400 AF"
combobox_accessory has 2 choices: "Pilot Light", "None"

so when the user makes the selections, he/she presses a command button and the code will call up data from a sheet depending on the selections. Here is my problem. An example code i did was something like this:

if combobox_dpfs_system = "System 1" And _
combobox_dpfs_af = "100 AF" and_
combobox_accessory = "None" Then

textbox1 = workbooks("Estimating Program 2014").Sheets("Kanye West").Cells(1,1)
textbox1 = workbooks("Estimating Program 2014").Sheets("Kanye West").Cells(2,2)
end if


if combobox_dpfs_system = "System 2" And _
combobox_dpfs_af = "100 AF" and_
combobox_accessory = "None" Then

textbox1 = workbooks("Estimating Program 2014").Sheets("Kim Kardashian").Cells(1,1)
textbox1 = workbooks("Estimating Program 2014").Sheets("Kim Kardashian").Cells(2,2)
end if

So i would do numerous if-then statements until i cover all the possibilites of the 3 combobox combinations. It is very tedious and i dont think this is the best way of doing it. Is there a way where there will be one IF-then main procedure and only variables will be changed? I really don't know I need help... Thanks...

Hi kjy,

You might want to put a logic table in a spreadsheet containing all the valid choices in your 3 combo boxes such as:
Column A - Combo Box 1 - system
Column B - Combo Box 2 - af
Column C - Combo Box 3 - accessory

Column D - Sheet Name
Column E - Something else chosen when A,B,C match

You would have several rows. When columns A, B, and, C match, then you use the item in Column D
(and possibly, E...) to do whatever you need to do. All the logic would be in the data tables, and not in the code. If there were impossible combinations, then they would not appear in the table, and you would have a 'NO MATCH' situation.

Lewis