Combo box used as selection for excel cell range

[fartbagxp]

I've been using the llb file found on this link to grab data from an excel sheet.

http://zone.ni.com/devzone/cda/epd/p/id/3409

My problem is that I want the cell ranges to be hard-coded according to what the user selected from a combo box.

Since my starting point in the excel sheet is always the cell (3, 2), I have gotten rid of the "start" control and hard-coded the starting input to (3, 2).  This works.

However, depending on what the user picks from the combo box, my ending point differs.  

Say... if he picks "Apples" from the combo box, the ending cell may be (15, 10), if he picks "Oranges", it'll be (9, 9).

I just started using labview a week ago, still trying to get accustomed to all the buttons.

Thanks!

[RavensFan · Accepted solution]

You should use a case structure.  Each case represents one of the items in the ComboBox and puts out whatever constants are needed to represent each of the Excel ranges you are interested in.

Since you've only been using LabVIEW for a week, I would recommend looking at the online LabVIEW tutorials
LabVIEW Introduction Course - Three Hours
LabVIEW Introduction Course - Six Hours