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 |
All times are GMT +1. The time now is 10:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com