Combo box remains empty due to missing rowsource in excel 2011

[BobdeB]

Hi there,

I am struggling a bit with folowing situatie. I created a userform which has 3 combo boxes and I am having trouble with getting the lists in each of there separate boxes.

The names of the lists are:
- Typeopdracht
- Statusopdracht
- Verdienmodel

The names of the combo boxes are:
- cboTypeOpdracht
- cboStatusOpdracht
- cboVerdienmodel

I found the following piece of code

Private Sub UserForm_Initialize()

With Worksheets("Projects")
Revenue_Account.List() = .Range("RevCategory").Value
End With
End Sub

and I rewrote it like this:

Private Sub UserForm_Initialize()
txtAangenomenOp.Value = Format(Date, "medium date")
Me.txtAdres.SetFocus

With Worksheet("blad9")
cboTypeOpdracht.List() = .Range("Typeopdracht").Value
cboStatusOpdracht.List() = .Range("Statusopdracht").Value
cboVerdienmodel.List() = .Range("Verdienmodel").Value
End With

End Sub

I don't know what I did wrong and besides that it now says that the sub or function isn't defined.

What do I do?

[Izandol]

It must be:

Please Login or Register  to view this content.

[BobdeB]

Opzet administratie (versie 1).xlsm

I tried that but that's not it. I can't figure it out. Blad9 is the worksheet where the lists are btw. Maybe should have mentioned that earlier.

I added the entire file in case i fail to explain myzelf properly.

[Izandol]

Blad9 is code name. You must use:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

[BobdeB]

Awesome, it works! Thanks

[Izandol]

You are welcome.