Listbox.ListIndex = -1
Listbox.TopIndex = 0
would show what is in cell A1 (which is blank). I believe that is what you
mean.

--
Regards,
Tom Ogilvy

bookworm98 wrote in message
...
What I mean is:
If I have a listbox1 which has a property List Range: A1:A3
A1="";
A2="1";
A3="2"; for example;
The list box I resize it into one row(Which will has up and down
buttons). Assume I used down button to choose the value 2(A3).
How can I set listbox1 appear blank.
I can use:
ListBox1.ListIndex = 0;
But it only affect when the ListBox1 is selected!
Help me!


---
Message posted from http://www.ExcelForum.com/