ComboboxStart item

  • Thread starter Thread starter alvin Kuiper
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 combobox change vlue 2
loop and some more 6
Loop and simple calculation 4
Macro to put data below data in a and b from columns c and d 4
Where is the problem on Next without For? 2
VBA set thick borders around non empty cells in range 0
Blank item in listbox, how to remove 3
search a row for data then move to next row 4

Back
Top