Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Default Row Height | Setting up and Configuration of Excel | |||
Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Data Validation list selection question | Excel Worksheet Functions |