SolidWorks Excel VBA

[tbirdcarl]

I am very new to writing VBA code and was hoping someone could help. I need a VBA that can alter an assembly of a cabinet in Solidworks.

B1 is the height
B2 is the depth
B3 is the width

C4 determines if there is a bottom options(Y or N)
C5 determines the number of doors ( 1 or 2)

I do not need the SolidWorks code. I need to know whether to use IF statements, Select Case, or if there is something I do not know about that would make this easier.
This is to tell what parts to select in the assembly


Please let me know if you need to have more information.
Any information is much appreciated.
I am using windows 7 and an older version of Excel 2000

 

[tbirdcarl]

I think it would be best to first determine whether there is a bottom or not
Then number of doors, and finally last to deal with the dimensions ( I can already alter dimensions on a generic cabinet.