| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboboxStart item
Hi I use:
Dim getmedia As Range Set getmedia = Sheets("Beregn").Range("media") For Each d In getmedia cbo_medie.AddItem d.Value Next How can i show the first item in the box, and not a empty line? Alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboboxStart item
Dim getmedia As Range
Set getmedia = Sheets("Beregn").Range("media") For Each d In getmedia cbo_medie.AddItem d.Value Next cbo_medie.Listindex = 0 -- __________________________________ HTH Bob "alvin Kuiper" wrote in message ... Hi I use: Dim getmedia As Range Set getmedia = Sheets("Beregn").Range("media") For Each d In getmedia cbo_medie.AddItem d.Value Next How can i show the first item in the box, and not a empty line? Alvin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboboxStart item
cbo_medie.Listindex = 0 will set that to the first entry
cbo_medie.Listindex = -1 will set that to blank If this post helps click Yes --------------- Jacob Skaria "alvin Kuiper" wrote: Hi I use: Dim getmedia As Range Set getmedia = Sheets("Beregn").Range("media") For Each d In getmedia cbo_medie.AddItem d.Value Next How can i show the first item in the box, and not a empty line? Alvin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to ask for a item# and then show all details for that item | Excel Discussion (Misc queries) | |||
| To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
| 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 | |||
| Pivot Item: removing non-existant item from the drop down | Excel Programming | |||
Linear Mode
