PDA

View Full Version : reload job nos fron jobs at J status



Rob342
02-20-2013, 06:24 AM
Further to last post answered by snb

I forgot to ask how do i find the row number, when the user selects one of the numbers at J stat

Thanks for your help by the way.
Rob

Private Sub UserForm_Initialize()
Dim j As Integer
Dim ws As Worksheet

Sheets("AC").Cells(1).CurrentRegion.Name = "snb_001"

CboJob2.List = Application.Index([snb_001], [row(snb_001)], Array(104, 5)) ' row 5 & 104
'CboJob2.List = CboJob.List
For j = CboJob2.ListCount - 1 To 1 Step -1
If CboJob2.List(j, 0) <> "J" Then CboJob2.RemoveItem j
Next

End Sub