after running the macro the list box content gets cleared

[akkinarula]

Hi All,

I m having the problem with my list box.

i've created one list box whose content i've taken from same sheet(i've written at the last column just to give range for list box)

and i've written one macro on one command button which retrives data from another sheet depending upon that list box.

Problem is that after running macro the content of the list box gets cleared and the same content which i've written at last column for list box purpose only also gets cleared

plz tell me if anybody knows solution for this.

 

[mikerickson]

It would help if we could see the macro that is emptying the list box.