View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sot sot is offline
external usenet poster
 
Posts: 19
Default Setting Combo Box to display a blank

I have a combo box on a user form. I have set the Row source as =list!a1:a5.
However when I display the form the value displayed in the combo box is the
one from the previous record.

How do I get it to clear and show a blank each time?