Create GUI in excel - user inserts part number & all applicable upgrades are shown.

Any help/guidance is greatly appreciated.!!!

I have 4 different Parent part marks (of various unique Part Numbers) which are made up of children parts (of different children part numbers).

Parent Part # examples:

mark I: 1-1, 1-2, 1-3
Mark II: 2-1, 2-2, 2-3
Mark III: 3-1, 3-2, 3-3

So 1-1 would be a Parent Part, as well 3-3, 2-4 and so on…(9 unique Parents Part # shown above)

(Children part # examples

(A1, A2, A3, A4, A5, A6......)
(B1, B2, B3, B4, B5, B6.......)
(C1, C2, C3, C4, C5, C6......)

Based on the unique parent part number – which will never be the same – there are available upgrades.

Upgrade ID’s:

A applicable to parent parts: 1-1, 2-1, 2-2, 2-3, 3-1
B applicable to parent parts: 1-3, 2-1, 2-2, 3-1, 3-2
C applicable to parent parts: 1-1, 1-2, 2-1
D applicable to parent parts: 1-1, 1-2, 1-3, 2-1, 2-2, 2-3, 3-1, 3-2, 3-3

(Each upgrade is made up of a list of parts which get added and/or replaced in a particular parent part)

WHAT I NEED MY SPREADSHEET TO DO:

1. I would like to create a GUI in excel where a user enters a parent part # and all applicable part upgrade ID’s are shown based on the Parent Part # (whether upgrade A, B, C and/or D).

2. Once all applicable upgrades are shown I would like the user to simply click a checkbox selecting which upgrades they would like (whether upgrade A, B, C and/or D).

The ultimate goal here is that once the user clicks certain upgrades the list of parts corresponding to that upgrade is retrieved and a cost calculated and returned. I am familiar with VBA and know that I have to use a Function to return a value. Should I keep all my tables in the same workbook? And what kind of table structure do you recommend?

Upgrade table fields include: Upgrade ID, Part Number, and Cost.

Again, your help/guidance is greatly appreciated.