Skip to main content
1-Visitor
November 9, 2011
Solved

How to save value of a listbox from an Excel Table?

  • November 9, 2011
  • 1 reply
  • 4479 views

I created a list box that can read values from an excel sheet.

By choosing different value on the listbox, the factor I need will change accordingly.

However, I can not save the value of the listbox, every time I close and re-open the MathCAD sheet, the listbox will go back to the first row.

I have been reading the posts on this website, a lot of people got simliar question of making custom controls persistent and there are answers for them. However, I guess since the values of the listbox I used is from the Excel table, the case is a little bit different.

Unfortunately, I am not good at VB at all, so if you can help me fix the script diretly, that will be perfect.

I attached the MathCAD file and the Excel table below. Please help me out with this.

Thank you very much!!!

Best answer by MikeArmstrong

In fact I've done it for you. Have a look at the attached. When it was saved I had selected the value 3.

Mike

1 reply

1-Visitor
November 9, 2011

Have a look at the attached worksheet and see if you can adapt it to your needs.

Mike

1-Visitor
November 9, 2011

Welcome to the forum by the way

Mike