View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Activesheet.Listbox1.ListIndex = 0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
This is probably very simple.

I have a list box (using control toolbox) in a work sheet and I want to
specify that every time the workbook is opened that the first item on the
list box is always selected

Thanks

Brian