Lookup I-Assembly row and column based on Combo box choice

[Anonymous]

Hello All!

this is my first post to this forum and so far I have found several pieces of code that have helped me learn parts of VBA. Thanks to all who reply in advance.

My employer has tasked me with the creation of a custom design program for the conveyor industry. My exposure to VBA is limited but I can set up a Userform, place controls, check if a user has selected options on the form, etc. I'm not totally green but I'm not at the point where I'm totally comfortable with some tasks (so use kid gloves please). What I'm stuck on is this:

I need to know how to look up an I Assembly row and column for particular conveyor sections. For example (see attachment), if the user selects "Intermediate" from the Section Type combo box on the first line, I would like the coding for reaching into the Intermediates I-Assembly table, populating the combo box for Description with the description values from the I-assembly Description column (I plan on using a combo box change event to handle when the user selects a different section type, perhaps "Idle" or "Drive"). Then when the user selects from the Description from the drop down and clicking "Build", the program will take the iRow and iColumn information to place into a new assembly and bolt the selected sections together.

the goal here is for Sales to be able to create lines on conveyor without engineering's help.  I have already set up  the sections with iMates so I plan on using the AddiAssemblyusingiMates example from the programming help to get me started then branch out from there.

Any snippets or clues are much appreciated.

I'm running Inventor 2014. the file path of the target I-assembly factory is:

T:\VAULT\Success Line\SS\LF882TAB-K450\Section Level Assemblies\Intermediates\Standard\LF882TAB-K450 SS INTERMEDIATE IASSEMBLY 12TO18.iam