Fish,

Either write each of the values to the registry, to a custom workbook
property, or a cell on a sheet.

HTH,
Bernie
MS Excel MVP

"FISH" wrote in message
...
Hello group,

I have a combobox in which I declared the combobox.value
once the drop down is selected I want it to store
the .value and other values between sub procedures. How do
I make it the procedure remember what has been declared in
the past decided values.

Thanks in advance.

Regards,

Fish