Reference Macro

[xlyreb01]

Good Day to everyone,

I would like to seek help regarding data reference,

i have been reading a lot of stuff and tutorials lately but it doesn't come to the point wherein i found what i was looking for, i'm good with suggestions or link reference that can help me solve my problem i'm not the skilled when it comes to excel macros but i'm eager to learn..
so here is my problem i want my combobox wherein i can input certain name reference and display its data.. i really just can't find the most certain lesson / tutorial for this been looking around everywhere to this specific topic.
Sample 101.xlsx
Thanks in advance

[skywriter]

I don't find a combo box? If it's not included then you should add it to your workbook and be specific in what you want to have happen.

[alansidman]

You might start by building a User Form instead of a drawing. Then use that Userform with Vlookup or Index/Match to get the data into the form

http://www.contextures.com/xlUserForm01.html

[xlyreb01]

is there an easier way wherein i can use vlookup/index/match with those combo boxes instead of vb?

[alansidman]

Seethe attached where I modified your lookup sheet. Also look at this link on Vlookup

http://www.techonthenet.com/excel/formulas/vlookup.php

[xlyreb01]

here sir i have create my sample userformSample 101.xlsm

[alansidman]

Here is the code to install on your submit button on your form. In the Vlookup, you will have to set your lookup range if it is greater than the six lines you have provided.

Please Login or Register  to view this content.

to make it easier on your users, you may wish to make textbox1 a combo box with the names of all your participants.

[xlyreb01]

Thank you sir, i'll get to try this one up

[xlyreb01]

its perfectly working sir, thank you so much for your help!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[xlyreb01]

done sir!, by the way, how am i able to use offset with vlookup in vb?

[alansidman]

Suggest you start a new thread with your questions. Since this is marked solve, no one will in all liklihood respond or look at it.