Skip to main content
1-Visitor
August 25, 2011
Solved

Store permanently combobox values.

  • August 25, 2011
  • 2 replies
  • 2153 views

Using Script with a combo box object, is there a way to store the last selected value in the worksheet, so it can be retained the next time the worksheet file is opened?

I see saving it into an outside file (.txt, .prn, or .csv) as an option, but is would not be practical in my workgroup environment.

Can I change a variable definition:

if I start a worksheet with:

a:=10

Can I script to change it into a:=15 for example... Like after the file is saved, the value is retained.

I could also use the Combobox script to initialize to the last saved value...

Best answer by RichardJ

In addition to the thread Wayne pointed you to, see here:Saving the state of controls.zip

2 replies

12-Amethyst
August 25, 2011

Sebastien Billaut wrote:

Using Script with a combo box object, is there a way to store the last selected value in the worksheet, so it can be retained the next time the worksheet file is opened?

I see saving it into an outside file (.txt, .prn, or .csv) as an option, but is would not be practical in my workgroup environment.

Can I change a variable definition:

if I start a worksheet with:

a:=10

Can I script to change it into a:=15 for example... Like after the file is saved, the value is retained.

I could also use the Combobox script to initialize to the last saved value...

Please see this thread

http://communities.ptc.com/message/45792#45792

RichardJ19-TanzaniteAnswer
19-Tanzanite
August 26, 2011

In addition to the thread Wayne pointed you to, see here:Saving the state of controls.zip