List box - setting default selection
 

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

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

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

"Bob Phillips" wrote:

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