Saving last ComboBox Selection on Reopen

  • Thread starter Thread starter Incredulous Dreamer
  • Start date Start date
I

Incredulous Dreamer

I was wondering if there is a way to save the last selection made in a
ComboBox such that when the file is reopened the last selection is shown.

I have already used a command button to LOCK the selections after choices
are made. But, when you close the file and reopen it, the combobox is
empty.

I've made sure the comboboxes are not cleared unless another "initialize"
command button is selected.

I'd like to setup the program so that when the user makes choices, the power
point file is saved and then when someone reopens the file they can see
previous user's choices and they are preserved unless actively changed.

Anyone know how to do this ?

Thanks,
Ed
 
You will need to save out the selections and then reload them via code on
restart. This can be done with a simple text file and an event trap.

On show end, save out all the combo box lists and the selections
On show start, recall all the list items from the text file. Then just run
thru the combo boxes and populate the text.


--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..
 
Great idea, Thanks.!
I also did something a bit cheesy. I overlaid a text box over the combobox
and then read the combobox text value into the text box text value. I then
turn on the visibility of the text box and turned off the visibility of the
combobox. This occurs when the combobox value is changed.

But, your method is a better for also recording the data.

Thanks again!

-Ed
 
You might consider storing the data within the presentation itself using
tags. This ensures that your recorded data travels with the presentation.
You can tag the presentation, the slides and the shapes.

Set a tag
call ActivePresentation.Tags.Add("MY_DATA","1")

Retrieve a tag
?ActivePresentation.Tags("MY_DATA")
1

--
Regards,
Shyam Pillai

Animation Carbon: Copy/Paste/Share animation libraries.
www.animationcarbon.com
 
You will need to save out the selections and then reload them via code on
restart. This can be done with a simple text file and an event trap.

Or if it's better to avoid external files, by storing the combo box values and
selected item as .Tags on the slide or combo box itself.
 
Back
Top