iAssembly - Excel - VBA

iAssembly - Excel - VBA

Anonymous
Not applicable
257 Views
0 Replies
Message 1 of 1

iAssembly - Excel - VBA

Anonymous
Not applicable
Hi to all
I have a problem in simple code
after creation of assembly file
went to Creation of iAssembly and include/exclude
some parts.
Next step - edit iAssembly via spreadSheet
created two ComboBoxes on sheet2 (sheet1 for Inventor only)
All data on sheet3 - "Data"
Now main part - coding in excell:

Private Sub ComboBox1_Change()
Select Case Sheets("Data").Range("n30")
Case 0: ComboBox2.ListFillRange = "Digit_6"
Case 1: ComboBox2.ListFillRange = "Digit_6a"
Case 2: ComboBox2.ListFillRange = "Digit_6"
Case 3: ComboBox2.ListFillRange = "Digit_6a"

End Select
End Sub

to this point all works OK - Combo box 2 changing its
contents depend of choise in combobox 1.

Afrer saving & exiting Inventor opening the same file
generate an error - see attached pgn.

Please help me - thanks for any ideas
Ursus Uziemblo
0 Likes
258 Views
0 Replies
Replies (0)