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
|