One Record Only
 

I have a gradebook. What i want to do is when one person opens it, it will
only see a userform with 3 textboxes. One is for data on column A, second
is data on column B and third is for data on column C. Example, i will input
the data of column A on textbox one, then i want text box 2 to be filled out
automatically with data on column B and same thing with textbox 3 with data
on column C. It's like vlookup on userform. Thanks for help.

One Record Only
 

In the workbook_open event, display the userform. In the userform, in the
textbox1 afterupdate or exit event, put in code to populate the other two
textboxes.

Not really sure what you question is.

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.



http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips

--
Regards,
Tom Ogilvy


boogie wrote in message
...
I have a gradebook. What i want to do is when one person opens it, it will
only see a userform with 3 textboxes. One is for data on column A, second
is data on column B and third is for data on column C. Example, i will
input
the data of column A on textbox one, then i want text box 2 to be filled
out
automatically with data on column B and same thing with textbox 3 with
data
on column C. It's like vlookup on userform. Thanks for help.