Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 26th 05, 07:25 PM
Brian
 
Posts: n/a
Default 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   Report Post  
Old January 26th 05, 08:23 PM
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Old January 26th 05, 08:47 PM
Brian
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting Default Row Height tinsel Setting up and Configuration of Excel 3 January 10th 05 07:39 PM
Setting up a random list from long list of names ? yorkshire exile Excel Discussion (Misc queries) 4 January 6th 05 01:44 PM
Setting default pivot table field setting to "sum" Mr. Moose Excel Discussion (Misc queries) 2 December 21st 04 04:43 PM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM
Data Validation list selection question Bob Wall Excel Worksheet Functions 2 December 4th 04 04:51 PM


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017