Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
How to display the first Item in a combobox as the default item | Excel Programming | |||
Don't add item in combobox ... | Excel Programming | |||
Combobox Add Item | Excel Programming | |||
ComboBox and select item | Excel Programming |