List box - setting default selection

B

Brian

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
 
B

Bob Phillips

Activesheet.Listbox1.ListIndex = 0

--

HTH

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

Brian

Thanks bob, I new it would be simple - have to remember that Activesheet part
next time
 
Top