How to save value of a listbox from an Excel Table?
- November 9, 2011
- 1 reply
- 4485 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!!!

