combobox with history function

[Örjan Skoglösa]

Hi,

I´m trying to make a userform with comboboxes that for the lifetime of
the document remember the added/edited values and displays them in the
dropdown list in "historical" order and with every value only once.

I´m using activedocument.variables to store the boxlist items until
the macro is run next time. But as I seem to be forced to organize
separat variable arrays for the three boxes involved, the code kind of
"explodes" and before starting out with this I just wondered if there
is a more simple way to accheive such a history function.

TIA
Örjan

 

[Word Heretic]

G'day Örjan Skoglösa <[email protected]>,

Long hand only :-(



Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Örjan Skoglösa reckoned:

 

[rlampky]

One method would be to link combobox to an access database. Following the
fine example from Dian an Word MVP,, you would be able to use and add any
items to the list repeatedly.

This example only shows a look up and populate, but you could refine it to
show a combo box on a userform and select the item. If it is not present
then the user would enter the info and update the database.

http://www.computorcompanion.com/LPMArticle.asp?ID=136

 

[Örjan Skoglösa]

Thanks.

I´ve had a look at the site and it looks most promising. I've
bookmarked it for use further use when I need to connect to a more
voluminous and long-lasting data source.

For the moment, when I only need to store new data for the lifetime of
a document, I followed Steve Hudson 'long hand' advice.

I also found out that I more easily than I thought could populate the
combo boxes from the variables and then (after deleting them) create
new variables with the new box content if I in three almost identical
loops used a concenated variable name that partly consisted of a "box
identifier".

Best regards,
Örjan