Thread: combobox issue
View Single Post
 
Old 07-29-2013, 09:47 PM
Deepa Shrestha Deepa Shrestha is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jul 2013
Posts: 3
Deepa Shrestha is on a distinguished road
Default combobox issue

Hello,

I have many ComboBox on a word worksheet. When you click on one of the ComboBox, a list of course unfolds. If you change the list, a macro automatically updates the list which is deployed in the ComboBox. So far, everything is normal.
I close the sheet and records the latest changes that were eventually made.
I open the file and then, all ComboBox list is reset. So I update via the macro to reappear.

How do I make lists of ComboBox remain unchanged at the opening of the macro enable file?
Reply With Quote