Skip to main content
P
ptc-30587781-Visitor
1-Visitor
January 5, 2010
Question

List Box script

  • January 5, 2010
  • 1 reply
  • 3408 views
How do I modify the list box script to enable the user selected value to be saved when the worksheet is closed. The purpose is to have the selected value displayed the next time the worksheet is opened?

1 reply

S
StuartBruff23-Emerald V
23-Emerald V
January 5, 2010

"Mark Carroll" wrote:

How do I modify the list box script to enable the user selected value to be saved when the worksheet is closed. The purpose is to have the selected value displayed the next time the worksheet is opened?

R
RichardJ19-Tanzanite
19-Tanzanite
January 5, 2010

"Stuart Bruff" wrote:

This topic has been addressed on the Mathcad Collaboratory - http://collab.mathsoft.com/ - can't remember where though. However, you're likely to get an answer more rapidly there than you are on this forum. Stuart

R
RobertWheeler1-Visitor
1-Visitor
January 8, 2010
I have been fighting with the scripting for this myself. The short answer is that you need to set up worksheet metadata to retain the state of these controls. If you are like me and you have no knowledge of VBScript, then you will need to cut/paste/hack from a sample file like this: download.ptc.com/products/mathcad/files/.../custom-controls13.xmcdz (Or search for "Persistence Mathcad file" and it should turn up.) If anyone reading this knows a good reference for VBScript usage in Mathcad, would you please let me know?
Terms & ConditionsAccessibility statement