Store permanently combobox values.

[Sebastien1]

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...

[wayne]

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

[RichardJ · Accepted solution]

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