View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
bookworm98[_7_] bookworm98[_7_] is offline
external usenet poster
 
Posts: 1
Default How to Clear value a listbox!

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 dow
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