Vlookup in a Form

[SebbeKine]

Hello,

I want to make a form with 2 textboxes and 2 commandbuttons.
The first textbox has to refer to te cellname Naam on the first sheet of the workbook. In the second textbox there wil be the result (with vlookup in the second row of the sheet) of the first textbox. The firts commandbutton is to close the form with no changes. The second commandbutton has to apply the change made in the second textbox. It has to search for the correct cell in the sheet.
In the sheet I have 2 coloms. In the firts there are names and in the second there are numbers.
I've made the form, but I don't know how to make the code.

I'm new in VBA.

Thanks

 

[JoeAtWork]

Umm, I think you want to look for the Excel VBA forum.

This is the Visual Basic 5 & 6 forum (it's not VBA).

 

[SebbeKine]

Oh sorry.

 

[JoeAtWork]

Not a problem. I'd give you the link if I knew it.

 

[johnwm]

Try forum707 - you can use the 'Find a Forum' link at the top of each page

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints