Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add/Edit/Save Info into Excel
Hey all,
I asked this question earlier but I wasn't specific enough. I have an excel sheet with info such as first name, Last name, email, and location. I already have a form that adds the info, I now need a second form or on another tab that populates a combo box with the last names, once you select the last name your looking for it fills text boxes with the other info from that row, you then can change that info and save it back to that same row. I do need help on the coding. Thank You in advanced for any help. Jay |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add/Edit/Save Info into Excel
XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/?id=161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/?id=213749 http://j-walk.com/ss/excel/tips/tip84.htm http://www.dicks-blog.com/excel/2004...g_userfor.html http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. -- Regards, Tom Ogilvy wrote in message ups.com... Hey all, I asked this question earlier but I wasn't specific enough. I have an excel sheet with info such as first name, Last name, email, and location. I already have a form that adds the info, I now need a second form or on another tab that populates a combo box with the last names, once you select the last name your looking for it fills text boxes with the other info from that row, you then can change that info and save it back to that same row. I do need help on the coding. Thank You in advanced for any help. Jay |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add/Edit/Save Info into Excel
Hi Jay,
There is a tutorial on this sort of stuff at http://www.edferrero.com/DataTutor01.aspx Hope it helps. Ed Ferrero Microsoft Excel MVP http://www.edferrero.com Hey all, I asked this question earlier but I wasn't specific enough. I have an excel sheet with info such as first name, Last name, email, and location. I already have a form that adds the info, I now need a second form or on another tab that populates a combo box with the last names, once you select the last name your looking for it fills text boxes with the other info from that row, you then can change that info and save it back to that same row. I do need help on the coding. Thank You in advanced for any help. Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow users to edit cells but not save the info | Excel Worksheet Functions | |||
Can I open, edit and save an Excel file online? | Excel Discussion (Misc queries) | |||
save edit share excel files on internet | Excel Discussion (Misc queries) | |||
Save default printer info in Excel | Excel Discussion (Misc queries) | |||
Add, edit, delete, save functions in excel using macros | Excel Programming |