ComboboxStart item

A

alvin Kuiper

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
 
B

Bob Phillips

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
 
J

Jacob Skaria

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
 
Top