Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to have a record number change for every record | Excel Discussion (Misc queries) | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Alt + Record | Excel Discussion (Misc queries) | |||
go to last record | Excel Programming | |||
Need help autopopulating next new record with previous record data | Excel Programming |