i have a toolbox combobox on my worksheet and want to populate it with the names of certain worksheets
Im trying the following but getting errors, any ideas please
For Each WS In ActiveWorkbook.Worksheets If WS.Range("D1").Value = "CRO Number" Then ComboBox1.AddItem = WS.Name End If Next