Docstoc

Form

Document Sample
Form Powered By Docstoc
					 Name         Date Joined  Amount Paid       I would like to enter data to a speadsheet with a userform.
 Smith     ###############   100.00          I want enter the data in a form that will automatically insert the data to
 Jones     ###############   200.00          the correct cells in my spreadsheet. And then allow me to enter new data on
  Patel    ###############   300.00          the next line below.
 Hicks     ###############   400.00
 Skilton   ###############   500.00          Is this possible?
  Shah     ###############   600.00
 Rajout    ###############   700.00
 Queen     ###############   800.00




                                             Add Form Button To Quick Access Toolbar:-
                                         1   Office Button (top left hand corner)
                                         2   Excel Options (lower right hand corner)
Format as Date * 14 March 2001           3   Customize
                                         4   Choose commands from:                Commands Not in the Ribbon
Format as Number                         5   Form
                                         6   Add>>
                                         7   OK
                                         8   A Form button will now be added to your Quick Access Toolbar

                                             To add records to this Workbook:-

                                         1   Highlight the range A 1 to C 9 inclusive
                                         2   Hit the Form button in your Quick Access Toolbar
                                         3   Select New
                                         4   Complete the 3 fields presented in the box
                                         5   Hit Close
                                         6   A new record will be added at row 10 above (starting in column A)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:8/23/2012
language:
pages:1