Encounter typing problem with userform

[tantcu]

Hi,

I just created a userform and I have a difficulty to navigate this userform to be more friendly user. whenever I hit "Tab" It won't go to the next box it will go from the bottom to the top and you can not type anything when you hit tab. Can you help me figure out the problem? I also want to be able to use Vlookup when the userform hit OK. The FS Acccount and His Account will look up the customer name from the "List" tab and automatically fill in the number when the userform is finised filled in.

Please see this attached
BAT REDO.xlsm

[Norie]

You can set the order the controls are tabbed through by right clicking the form and selecting Tab Order.

[tantcu]

Thanks. It worked well when I changed the order from the TabIndex. Do you know how to do the Vlookup automatically?

[Norie]

Don't change the TabIndex property of individual controls as that can affect other controls.

Use the Tab Order dialog I mentioned.

As for the VLookup, just put code in the click event of the OK button.

[tantcu]

I can't find the Tab Order dialog when I right click.

Do you know the code for Vlookup!

[Norie]

Strange I can find it no problem, make sure you are clicking on the actual form itself and don't have any controls selected.

What is it you want to lookup?

[tantcu]

I want to Vlookup to get the FS Account and His Account in the "BatTab". The data is from the "List" Tab

[Norie]

You can get the corresponding FS/His accounts for the selected customer from 'BatTab' like this.

Please Login or Register  to view this content.

[tantcu]

Do You know where I should put the code? I put it in either OKButton Click and UserForm Initialize and did not see anything happen in Column C3 & C4 in the BAT tab.

[Norie]

The code would go in the OK button's click event.

It only gets the account numbers for the selected customer and puts them in variables, nothing else

What happens next is up to you, and it's not something I know about.

If they are supposed to go in C3 and C4 on 'BAT'.

Please Login or Register  to view this content.