Is this a combobox from the control toolbox that's been placed on a worksheet?

If yes, how about using a linkedcell (on a hidden worksheet???).

If the workbook is saved after the choice, it should be remembered the next time
the workbook opens.

sonu wrote:

Hi,

I want to creat a combo box that remembers what value is selected
when it was used the last time.

For example I want to create a comb box where you can select column A
thru Z. If the uses selects column B the first time he used the
application I want this combo box to show this value when next time
the application is started again.

Is there a type of variable I can use for this or I have to save the
value somewhere and just read it from there the next time.

Please let me know if there is a better way of doing this.

Thanks
Sonu

--

Dave Peterson