On ComboBox change get data with reference of Job number

[skhari]

Dear Experts

I am trying to get value from cell to Userform with the reference of Job Numbers
Worksheet named "Master"
Job Number : P2:P (JobNumCB)
eg. P2=1, P3=Plumbing,P4=30,P4=35,.....
Job Reference Code " Q2:Q (JobRefCodeLB)
eg. Sometext/num/Part

Only if i select "Plumbing" I am getting relevant answer
I am having result only if i select text but not number

I trying this code below. Please help !!!
Attached" image reference

Private Sub JobNumCB_Change()
Dim JNCB As String
 
    Dim FJNCB As Range
     
    'sets the variable JNCB equal to the value in the JobNumCB
    JNCB = JobNumCB.Value
    'selected the Master worksheet
    Worksheets("Master").Activate
    'set the variable equal to the found cell in the Master worksheet
    'whose value is equal to the SellerNameCB value
    Set FJNCB = Sheets("Master").Cells.Find(what:=JNCB, LookIn:=xlFormulas, lookat:=xlWhole)
     
    'if the value is not found then do nothing
    If FJNCB Is Nothing Then
    JobRefCodeLB.Caption = "Job Ref. Code"
    Exit Sub
    Else
       
        Application.Goto FJNCB
        
        JobRefCodeLB.Caption = ActiveCell.Offset(0, 1).Value
        Worksheets("Controls").Activate
 
    
 
   Exit Sub
   End If
End Sub

[Marc L]

Try with JobNumCB.Text …

If not works, attach workbook.

[Fotis1991]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.