Can you control Configurations through VB and Excel?
Can you control Configurations through VB and Excel?
(OP)
It is possible to control a configuration through VB? I would like to create a drop down box in Excel That would link to a configuration changing about 10 dimensions in a part. I want have two separate parts in a top level assembly change to the same configuration. What is the simplest way to accomplish this?
Thank you!
Gwen
Thank you!
Gwen





RE: Can you control Configurations through VB and Excel?
BeforeDragOver
BeforeDropOrPaste
Change
DblClick
DropButtonClick
Error
GotFocus
KeyDown
KeyPress
KeyUp
LostFocus
MouseDown
MouseMove
MouseUp
The combobox has properties
LinkedCell which you can use to link the combo box selection to a cell in the worksheet containing the combobox
ListFillRange which you can use to populate the Combobox using a list located in a range of cells on the worksheet.
It is also possible to change the list on the fly using the addItem method.
Gwen, you asked
the short answer is yes. However, it takes a little practice. Start by exploring the VB Editing environment. Use Alt-F11 to get there.
RE: Can you control Configurations through VB and Excel?
Yesterday I downloaded Drive Works which may be the solution to my problem.
Thank you very much for your response! Have you worked with drive works by chance?
Gwen
CSWP