×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Can you control Configurations through VB and Excel?

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

RE: Can you control Configurations through VB and Excel?

The most flexible drop down box to use with VB code can be selected from the Control Toolbox tool bar rather than the Forms tool bar.  The Control Toolbox contains  the Combo Box activeX control (simillar to the drop down) which can initiate code in response to an event that occurs in the spreadsheet.  For example you can create event procedures for any of the following events associated with the combobox:

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

Quote:

It is possible to control a configuration through VB?
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?

(OP)
I have used VB to link Dimensions to Excel Cells.  But I do not know the syntax for controlling configurations through VB.  I would like to link a drop down box value to a confutations name.  

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources