Skip to main content
SA_99507291-Visitor
1-Visitor
Jun 5, 2021 12:40 PM UTC
Solved

Combo-box alternative methods of utilisation

Hi All,

 

These may be some stupid questions, but new to this environment from an excel background...

 

I have a number of questions which pertain primarily to how to use data within list / combo-box etc. to be able to extract a number of standard parameters associated with, snippet's below & file attached

 

SA_9950729_1-1622896603765.pngSA_9950729_2-1622896629060.png

 

ttokoro
ttokoroAnswer
21-Topaz I
Jun 9, 2021 11:26 PM UTC

4 is fixed.

5. Using global  = to select the i index. This is my favorite method.

 

image.pngimage.pngimage.png

 

t.t.
View in thread

8 replies

Fred_Kohlhepp23-Emerald I
23-Emerald I
Jun 5, 2021 3:54 PM UTC

Let me start by saying that I have NEVER been a fan of combo boxes.  And I'm confused by your sheet.  It seems that there are things missing.  (You need to have T.Cat defined to have vlookup work.)

 

That said, What you're showing has drawbacks.  For what you've shown, I would build a table.  (Tables replaced  data arrays from Mathcad 15.  If you select data in EXCEL and paste it into Prime, you get a table with blank headers:

Fred_Kohlhepp_0-1622908058794.png   Fred_Kohlhepp_1-1622908124055.png

One advantage of tables is that they allow units.  (Combo boxes will too, but that can get tricky, look for previous posts!)  In tables, you type variable names and units, and you get arrays.

Fred_Kohlhepp_2-1622908348178.png

And a lookup is just as easy:

Fred_Kohlhepp_3-1622908438442.png

 

 

Translate
    SA_99507291-VisitorAuthor
    1-Visitor
    Jun 9, 2021 5:21 PM UTC

    @Fred_Kohlhepp  thanks for that.

     

    At this stage I want to try different methods to give me the best overall options to use Math cad, as have a lot of problems to resolve if I am to be able to make use of this..

     

    Appreciate your thought's on what you consider to be a better product, & have updated the sheet I had to include your suggestion, & tweaked what I can of the others to make it more useful..

    Translate
    ttokoro
    ttokoro21-Topaz IAnswer
    21-Topaz I
    Jun 9, 2021 11:26 PM UTC

    4 is fixed.

    5. Using global  = to select the i index. This is my favorite method.

     

    image.pngimage.pngimage.png

     

    Translate
    t.t.
      Terms & ConditionsAccessibility statement