VLOOKUP Funtion within a User Form

[bern494]

Hi All
I have user form that I use to imput data in a worksheet from Job report forms from Engineers.
I want to put a text box with code on the user form which will read from a combo box on the user form (which will have a venue) and vlookup a code form a list in the workbook which include all venues along with there own code.
Hope this makes sense, basically some code on a user form to read from a combo box to give a code number.

Any help please

Bern

 

[bern494]

reply

Hi All
Due to the limited response to my query perhaps I can just try to explain further what I am trying to achieve.
In my user form I have a combo box (Venue) from which I can choose from up to a hundred different venues. Each of these venues has differing codes for pricing purposes. I.e. Birmingham is in code A or Southampton is a code C...

In another combo box (Band Code) I have a choice of call types i.e. A7 which is the venue code and the number of hours to respond.
There could be up to hundred venues which are all coded either A, B, C, D.

I would like a box to give me the code for that venue in a separate box so I can choose the appropriate code in the Band code
The code would read something like =Vlookup Venue, Codes, 2
But I cannot seem to implement it or where? (Codes being a list of venues and band codes in the worksheet)

Any Help please
Bern