textbox dependent on 2 combo boxes (user form) VBA

Hi Guys,
I'm a newbie and was wondering if someone out there can shed some light on my dilemma with my code.

I'm currently have creating a user form and I have a worksheet (master) that has 3 columns...col B:State, col C:Profession, col D:Salary

On the excel side I have a code which works(perfectly) like this: =VLOOKUP(C40&"|"&C44,CHOOSE({1,2},master!B3:B12086&"|"&master!C3:C12086,master!D3:D12086),2,0)

what it does is, that when a state is chosen from the pulldown and a profession is chosen from the profession pulldown, it refers back to my master worksheet range and
returns the particular salary value, correlating to the particular state and profession into the cell.

My questions is, how can I translate this formula to work in VBA coding for my user form to work the same as my excel.

Any help or insight will be greatly appreciated.

Thanks Tinbendr,

I tried it but it didn't work. It has though given me a platform to begin from. One of the errors I got was {}, are not recognized apparently, in VBA coding.
I did make a change too, where I failed to indicate that c40 is actually the combobox for State and c44 is actually the combobox for for Profession, to choose from.

The following is the way I changed it in VBA.....

Private Sub tbox1_Change()

Me.comboState.Value=v1
Me.comboProfession.Value=v2

Me.tbox1=Application.WorksheetFunction.Vlookup(("v1") & ("v2"), CHOOSE ([1,2], Worksheets(master).Range("b3:b12086") & _
Worksheets(master).Range("c3:c12086"), Worksheets(master).Range("d3:d12086")), 2,0)

End Sub