Skip to main content
P
ptc-42609121-Visitor
1-Visitor
October 5, 2011
Question

Combobox

  • October 5, 2011
  • 5 replies
  • 13002 views

Hello,

when a mathcad sheet has a combobox, and I try to open it, i get an error message" an unknown runtime error occured, existing". what do i need to do to be able to open any mathcadsheet with combo boxes? Thanks!

5 replies

V
VladimirN24-Ruby III
24-Ruby III
October 6, 2011

Hello!

Which version of Mathcad you are using and what OS is running?

P
ptc-42609121-VisitorAuthor
1-Visitor
October 11, 2011

I have Mathcad14, and Windows XP. Thanks!

V
VladimirN24-Ruby III
24-Ruby III
October 12, 2011

SAM FARES wrote:

Hello,

when a mathcad sheet has a combobox, and I try to open it, i get an error message...

Could you also to attach a Mathcad worksheet?

Here's a tip how to attach a file:

1. Step

Pic_1.jpg

2. Step

Pic_2.jpg

P
ptc-42609121-VisitorAuthor
1-Visitor
October 13, 2011

Attached is the mathcadsheet you requested. Thanks!

R
RichardJ19-Tanzanite
19-Tanzanite
October 12, 2011

Please post an example worksheet.

P
ptc-42609121-VisitorAuthor
1-Visitor
October 12, 2011

Hello Richard,

when i am replying to you, how could i attach the mathcadsheet?

R
RichardJ19-Tanzanite
19-Tanzanite
October 12, 2011

At the top right it says "Use advanced Editor". Click on that, then you will be able to attach files.

The advanced editor used to be the default. I don't know why they changed it.

J
jsheehan1-Visitor
1-Visitor
October 15, 2011

All seems to work fine if your path to AISC 13th EDITION.xls is set properly. I would recommend making filename a variable in your worksheet such as filename = "AISC 13th EDITION.xls" and pass it to each of your combo-boxs which open the Excel worksheet. Or you coudl simply add into each combo-box script

filename = Worksheet.Getvalue("filename")

If the path to your file i snot correct you'll get a runtime error from the following line

Set objWorkbook = objExcel.Workbooks.Open("D\jsheehan\support\2011\AISC 13th Edition.xls")

P
ptc-42609121-VisitorAuthor
1-Visitor
October 15, 2011

Thanks John!!

in the attached mathcadsheet, i have to type in the code, beam, support, which is a bit inconvient. how would you setup a list box or a combo box i am not sure the difference between the two so that al i need to do is scroll down and select the beam size , or support size which are looked up in the table inside Beam and support data area. as far as the code eithe "ASD" or LRFD"?

R
RichardJ19-Tanzanite
19-Tanzanite
October 15, 2011

Does your positive reply mean that if you put the Excel spreadsheet in the correct path it works? If so, that's surprising, since you said you could not open the worksheet I posted above that does not access the spreadsheet.

i am not sure the difference between the two

They are listboxes. Mathcad does not offer comboboxes as controls.

how would you setup a list box or a combo box i am not sure the difference between the two so that al i need to do is scroll down and select the beam size , or support size which are looked up in the table inside Beam and support data area. as far as the code eithe "ASD" or LRFD"?

I'm confused. Isn't that what the listboxes in your other worksheet already do?

V
ValeryOchkov24-Ruby IV
24-Ruby IV
October 15, 2011

I think the combo box in Mathcad is not a correct combo box.

The correct combo box is a combination a text box and a list box:

combobox.png

Terms & ConditionsAccessibility statement