Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default How to display the first Item in a combobox as the default item

Try setting the L:istIndex value to 1

--
Cheers
Nigel



"Jeffery B Paarsa" wrote in message
...
Hello,

I am initilizing and adding about 15 items from a range to a combo box
before I display the userform. Instead of showing blank inside of combo
box
when I display the user form, I would like to set the first item as the
default item when showing userform. I tried to set the Topindex to 1, 0
but
it does not accept it.
--
Jeff B Paarsa



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default How to display the first Item in a combobox as the default item

Oops sorry set it to 0 (or of course any valid value in the list!

--
Cheers
Nigel



"Nigel" wrote in message
...
Try setting the L:istIndex value to 1

--
Cheers
Nigel



"Jeffery B Paarsa" wrote in message
...
Hello,

I am initilizing and adding about 15 items from a range to a combo box
before I display the userform. Instead of showing blank inside of combo
box
when I display the user form, I would like to set the first item as the
default item when showing userform. I tried to set the Topindex to 1, 0
but
it does not accept it.
--
Jeff B Paarsa





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,441
Default How to display the first Item in a combobox as the default ite

Jeffrey,

UserForm1.ComboBox1.ListIndex = 0

HTH,
Bernie
MS Excel MVP


"Jeffery B Paarsa" wrote in message
...
I am sorry I don't see ListIndex parameter on the property of my ComboBox!
How do you set this ListIndex? I can only see the TopIndex on the property
of my Combobox!
--
Jeff B Paarsa


"Nigel" wrote:

Try setting the L:istIndex value to 1

--
Cheers
Nigel



"Jeffery B Paarsa" wrote in message
...
Hello,

I am initilizing and adding about 15 items from a range to a combo box
before I display the userform. Instead of showing blank inside of combo
box
when I display the user form, I would like to set the first item as the
default item when showing userform. I tried to set the Topindex to 1, 0
but
it does not accept it.
--
Jeff B Paarsa






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
Item numbers result in item description in next field in Excel Cheryl MM Excel Worksheet Functions 1 February 20th 07 03:51 PM
How to display the first Item in a combobox as the default item Jim Cone Excel Programming 0 December 8th 06 06:42 PM
Don't add item in combobox ... Marie J-son[_7_] Excel Programming 4 December 9th 05 03:04 PM
Combobox Add Item MBlake Excel Programming 4 May 2nd 05 04:15 PM
ComboBox and select item Soniya Excel Programming 5 August 23rd 03 11:18 AM


All times are GMT +1. The time now is 10:09 AM.

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

About Us

"It's about Microsoft Excel"