Getting a combo/list box to populate based on the other

New User here,

Hopefully someone can help me try and sort a problem that my head just can't get around. I have the USer form set up and working etc. However I would like to know how to populate a combo / list box to populate based on the selection in another.

I have a worksheet with 2 colums i.e Column 1 = Report Name, Column 2= How the report is output. So in essence A2 is directly related to B2 and are dependent on nothing else.

I just can't get this working in VBE.

Any help would be greatly appreciated.

Niall

Originally Posted by royUK

Try this amended code

Private Sub cboReport_Change()
Me.cboOutput.ListIndex = Me.cboReport.ListIndex
End Sub

Private Sub cmdClose_Click()
  Unload Me
End Sub

Private Sub UserForm_Initialize()
Dim cReport As Range
Dim cOut As Range
Dim ws As Worksheet
Set ws = Worksheets("ReportLookup")

   Me.cboReport.List = ws.Range("Report_Name").Value
   Me.cboOutput.List = ws.Range("Output").Value
End Sub

RoyUK,

You have sorted in under 1 minute what has taken me days not to find out. Superb and thank you so much for this. Very much appreciated. No doubt I will be back to annoy (consult) you soon.

Super.

Thanks again,

Niall