On Mon, 4 Aug 2008 11:59:01 -0700, Rivers
wrote:

sorry guys

i think we have our wires crossed a little

the list box has a row source linked to the spreadsheet. when the macros
done it clears the rows of data that the list box looks at thus turning the
list box blank.

however the option i selected before running the macro say line 3 of the
list box is still coloured blue its value is empty but still highlighted im
looking for a way to turn the list box from being highlighted after i have
run the macro


I never use rowsource.
http://www.dailydoseofexcel.com/arch...stboxcombobox/

However, I think you need to code

Me.ListBox1.Rowsource = ""

when you clear the range. And reset it to the range address when you
repopulate the range (or sometime just before you show the form).
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com