Message 1 of 1
iAssembly - Excel - VBA

Not applicable
05-23-2008
06:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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
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