cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Excel - Prime 7. Change combo box through API

DM_10127316
7-Bedrock

Excel - Prime 7. Change combo box through API

Hi,

 

I have a combo-box with in a mathcad sheet that I would like to change through Excel + VBA. The combo box is something like this:

option1 ¦ 0

option2 ¦ 1

etc

The idea is to change from excel the state of the combo box. I can add it as an input, so it seems possible but I don;t know what variables I need to pass. I tried "option1" and 1 without luck, VBA tells me that I cant pass that variable to the combo box.

Anyone has experience with this?

 

Regards, 

 

3 REPLIES 3

Hi,

Please upload both the Prime worksheet and Excel workbook.

If the workbook has macros you may need to put them in a zip archive to upload?

Cheers

Terry

Thanks for your reply @terryhendicott 

I Isolated the issue in the attached files. Note: for the excel file to work, the Mathcad file location must be changed.

 

The idea is to change the combo box from Excel.

 

A not ideal way would be to replace the whole combo box by its value.

 

Regards,

Hi,

 

You cannot change the Prime ComboBox with API code.

If you input a value to the combobox alias you delete the Prime Combo Box. 

Capture.JPG

You can fully programmatically control a combobox as part of VBA coding.

Simply create a userform and add a combobox in VBA.

.

Capture2.JPG

Cheers

Terry

 

Top Tags