Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.templates
|
|||
|
|||
Data Input Execl Form
Hi,
I am trrying to create an execl form to dsiplay/edit data stored in rows on a excel sheet. In my form I should be able to select an ID (refering to one of my table row), and display/edit the attributes of this row item. Is forms the best way to do that? Do you have some links pointing at ressources/examples to do that? Regards, Seb |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.templates
|
|||
|
|||
Data Input Execl Form
All references are applicable to xl97 or later:
XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/default...;en-us;Q161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/search/...;en-us;Q213749 Here are some other sources of information: 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 http://support.microsoft.com/default...;EN-US;Q168067 File Title: Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 File Name: WE1163.EXE File Size: 161742 bytes File Date: 05/08/97 Keywords: kbfile Description: This Application Note is an introduction to manipulating UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual Basic for Applications macros that show you how to take advantage of the capabilities of UserForms and use each of the ActiveX controls that are available for UserForms Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp -- Regards, Tom Ogilvy "Seb" wrote in message om... Hi, I am trrying to create an execl form to dsiplay/edit data stored in rows on a excel sheet. In my form I should be able to select an ID (refering to one of my table row), and display/edit the attributes of this row item. Is forms the best way to do that? Do you have some links pointing at ressources/examples to do that? Regards, Seb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Reset data input form | Excel Worksheet Functions | |||
data validation in Execl 2007 | New Users to Excel | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
How can I have an input form to add a random no. to each input entry? | Excel Discussion (Misc queries) | |||
format cell from data input to output form | Excel Worksheet Functions |