Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data entry form
The data entry form adds the line of data to the bottom of the database
worksheet. What I'm wondering is if the data entry form can add it to the top, so that the first record entry is at the bottom, and the most recent listed at the top. Since my intuition is that the data entry form cannot do this, I'm wondering if I can have a data entry worksheet and program a macro or some other method to have the database reversed on a different worksheet. The boss wants to view the most recently added record at the top of the worksheet, but someone else is entering the data, so if I can at least get Excel to display a worksheet opposite of how the data is entered, that would satisfy his needs. Any ideas? Thanks! BTW, using Excel 2003 SP1. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data entry form
You are going to have to learn a little about VB first but this is what you
need to do Access the VB editor ALT & F11 Create a userform and then add the required field for your data, do this by creating a number of textboxs onto your userfom and stick a command button onit. Insert a code like this within the userform, to access where to enter code double click the userform Sub commandbutton1_click Rows("1:1").Select Selection.Insert Shift:=xlDown range("A1).value = textbox1.value end sub I know its not much but it will give you a start If you have any problems contact me at Within Excel create -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry Form | Excel Discussion (Misc queries) | |||
data entry form | Excel Discussion (Misc queries) | |||
Data Entry Form (similar to default Excel DataForm) | Excel Programming | |||
Data Entry Form | Excel Programming | |||
Help with data entry form please | Excel Programming |