A Form To Feed An Excel Worksheet

Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a 
mini-database with names and addresses, etc. to feed into a Word 2007 mail 
merge. Typing in all the data in the Excel worksheet is going to be tedious.

I'm wondering if there is something equivalent to a "form" that you can 
create in Access. In Access, a "form" is something with fields that you can 
group in a convenient order on the "page" of the form, and then you can tab 
through them and type in data. I think one could create such a thing in 
Access, and feed an Access database. I'm hoping the equivalent thing can be 
created in Excel. If you have any information that applies to earlier 
versions of Excel, I'm sure that will still be useful info for the 2007 
version. Thanks.

dc
0
DeeDeeCee (14)
8/2/2007 3:26:04 AM
excel 39879 articles. 2 followers. Follow

4 Replies
486 Views

Similar Articles

[PageSpeed] 49

In Excel version 2003 I would check out Data > Form...

But don't know the 2007 equivalent.


-- 
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"DeeDeeCee" wrote:

> Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a 
> mini-database with names and addresses, etc. to feed into a Word 2007 mail 
> merge. Typing in all the data in the Excel worksheet is going to be tedious.
> 
> I'm wondering if there is something equivalent to a "form" that you can 
> create in Access. In Access, a "form" is something with fields that you can 
> group in a convenient order on the "page" of the form, and then you can tab 
> through them and type in data. I think one could create such a thing in 
> Access, and feed an Access database. I'm hoping the equivalent thing can be 
> created in Excel. If you have any information that applies to earlier 
> versions of Excel, I'm sure that will still be useful info for the 2007 
> version. Thanks.
> 
> dc
0
Wigi (97)
8/2/2007 8:16:02 AM
Wigi wrote:
> In Excel version 2003 I would check out Data > Form...
> 
> But don't know the 2007 equivalent.
> 
> 
I can't find the 2007 equivalent either. There's no "Form" on the Data 
ribbon and searching for "data entry form" in Help yields no decent 
results. Neither does right clicking on selected cells to create such a 
form.

Did MS take out this feature?

Bill
0
wfsnopam (66)
8/3/2007 9:51:04 PM

"DeeDeeCee" escribió
> Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a
> mini-database with names and addresses, etc. to feed into a Word 2007 mail
> merge. Typing in all the data in the Excel worksheet is going to be 
> tedious.
>
> I'm wondering if there is something equivalent to a "form" that you can
> create in Access. In Access, a "form" is something with fields that you 
> can
> group in a convenient order on the "page" of the form, and then you can 
> tab
> through them and type in data. I think one could create such a thing in
> Access, and feed an Access database. I'm hoping the equivalent thing can 
> be
> created in Excel. If you have any information that applies to earlier
> versions of Excel, I'm sure that will still be useful info for the 2007
> version. Thanks.
>
> dc

Hi Dee

This command is availlable from the Excel Options area in Excel 2007. You 
can add it to the Quick Access Toolbar if you use it often.
To add a command to the Quick Access Toolbar:
1.Click the microsoft office Button, and then click Excel option.
2.Click customize.
3. In the Choose commands from list, click All commands, and then find the 
commad form...


http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT101493291033&vwidth=1044&vheight=788&type=flash&CTT=11&Origin=HA101491511033

infinitogool
 

0
8/4/2007 2:18:33 PM
infinitogool wrote:
> 
> 
> "DeeDeeCee" escribió
>> Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a
>> mini-database with names and addresses, etc. to feed into a Word 2007 
>> mail
>> merge. Typing in all the data in the Excel worksheet is going to be 
>> tedious.
>>
>> I'm wondering if there is something equivalent to a "form" that you can
>> create in Access. In Access, a "form" is something with fields that 
>> you can
>> group in a convenient order on the "page" of the form, and then you 
>> can tab
>> through them and type in data. I think one could create such a thing in
>> Access, and feed an Access database. I'm hoping the equivalent thing 
>> can be
>> created in Excel. If you have any information that applies to earlier
>> versions of Excel, I'm sure that will still be useful info for the 2007
>> version. Thanks.
>>
>> dc
> 
> Hi Dee
> 
> This command is availlable from the Excel Options area in Excel 2007. 
> You can add it to the Quick Access Toolbar if you use it often.
> To add a command to the Quick Access Toolbar:
> 1.Click the microsoft office Button, and then click Excel option.
> 2.Click customize.
> 3. In the Choose commands from list, click All commands, and then find 
> the commad form...
> 
> 
> http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT101493291033&vwidth=1044&vheight=788&type=flash&CTT=11&Origin=HA101491511033 
> 
> 
> infinitogool
> 
> 
Thanks! MS sure hid that feature pretty well in Excel 2007!

Bill
0
wfsnopam (66)
8/4/2007 5:48:41 PM
Reply:

Similar Artilces:

Can i recall an entire list in an excel spreadsheet
Can i create a formula that will recall a list of data bound by a course number. For example if i have a book list which are separated by subject type can i recall this list by entering a single piece of data. What do you want to do with the entire list?, do you want to be able to select one or do you want to use it in a calculation? Luis Verdejo;575226 Wrote: > Can i create a formula that will recall a list of data bound by a course > number. For example if i have a book list which are separated by > subject > type can i recall this list by entering a single pi...

Reservation Form
I have an active website for my business. I built it in Frontpage 2002. It no longer will send email through the settings I used ( Reservation form) and I cannot get it to take any of the settings I give it. I do not think that my knowledge is sufisticated enough. And, I don't think that I am entering the information completely enough. I am using a simple form with a single enter button. Can you help? May be possible. -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression Web "FrontPage 2002 on windows XP" <FrontPage200...

save excel file to xml
how can I save a excel file to xml? Thanks, qq In Excel 2003, save as XML spreadsheet. "XML spreadsheet" is a drop-down choice in the File Type shown in the Save As dialog box. Bill <quickcur@yahoo.com> wrote in message news:1104798698.421024.161510@z14g2000cwz.googlegroups.com... how can I save a excel file to xml? Thanks, qq ...

Auto populate a form form an open form
Hi I have a main form with customer names and addresses and would like to add a control button on this form which opens up another form which is used for recording telephone calls on. What I have been trying to do is auto populate this call log form with information from the main form ie name and address? Any thoughts Thanks Chris Chris, Please don't re-post the same question twice. You have to be patient and wait for a reply. Responders are volunteers, and you may not get an answer right away. Posting twice causes some people to respond to the first post, while others are ...

moving worksheets
How can I move a worksheet within the main excel window,when the worksheet header has become hidden behind the toolbar. You could resize the window: Window|Arrange|tiled To see all the tabs and titlebars then rearrange each by manually. steve budd wrote: > > How can I move a worksheet within the main excel > window,when the worksheet header has become hidden behind > the toolbar. -- Dave Peterson ec35720@msn.com Click Window,Arrange which should treat all open windows the same (tiled or cascaded) The hidden header will then become visible. "steve budd" <ano...

Excel 2007 lock-up
In Excel 2007, while saving a spreadsheet; selecting, deleting or inserting columns; etc, an hourglass appears on my monitor and I can hear the local hard disk spinning (the sound is more noticeable than when the hard disk is not being accessed). But, after the process ends, the hard disk repeatedly speeds up and slows down and I can't work on the spreadsheet (the hourglass remains on my monitor). Task Manager's "Application" page shows that "Microsoft Excel" is "Not Responding". And, the "Processes" page shows that the "Mem Usage" fo...

form pozition on screen
I would like to find form position on screen. It's similar to DoCmd.movesize, but I want discover "parameters' for form position (left corner, top corner, etc) Are you saying that you want to find out what the current position IS? If so, you can use something like this: MyFormLeftVariable = Me.Left MyFormTopVariable = Me.Top MsgBox "My Form is at " & MyFormLeftVariable & VbCrLf & MyFormTopVariable Or however you want to use it. -- Bob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com ___________...

copy properties Under forms
Hi, I'm wondering if someone can help me with something on copying properties. I've checked the access help but can't find anything there. This is what i want to do. I'm copying text boxes, labels that has caption, name and other information in the properties that i want to keep when i copy the information to another tab on a form. Is there a way i can copy the property information without doing alot of manual work by going into each text or label box. I hope this makes sense. thanks for you help in advance. Keith When you copy a control, everything about the cop...

arrow moves in excel
The arrow keys are moving the entire grid. It is not moving from box to box. What needs to be changed? Hi Roger. Check your scroll lock button. -- Sincerely, Michael Colvin "Roger Quigley" wrote: > The arrow keys are moving the entire grid. It is not moving from box to box. > What needs to be changed? This corrected the problem. Thank you Roger "Michael" wrote: > Hi Roger. Check your scroll lock button. > -- > Sincerely, Michael Colvin > > > "Roger Quigley" wrote: > > > The arrow keys are moving the entire grid....

How do i calculate the time between 10:00 pm and 6:00 am in excel?
I working on a 2 week schedule for my employees. What i need to know is, how do I calculate the time between 10:00 pm and 6:00 am in excel? XL stores times as fractional days (so 03:00 = 0.125). Since times roll over at midnight, you have to add 1 (a full day) to the later time if your values times spand midnight. You can use the fact that XL coverts boolean TRUE/FALSE values into 1/0, respectively, in math functions: A1: start time B1: end time C1: =B1 - A1 + (B1<A1) or the more obscure but equivalent C1: =MOD(B1-A1, 1) See http://cpearson.com/excel/datetime.h...

What is the purpose of 'Dummy' window in the Command forms
I am wondering why GP has Dummy window with title "~internal~" for the Command forms. For example Command_Financial form has Dummy window Do I need to create Dummy window for my Command forms. If so why I need it. Any comments appreciated!!! Hi Mandeep, The Dummy window is there as a placeholder. It really doesn't do anything, but should be there in order for the form to work properly since your form needs to be open for the commands to be available. The title ~internal~ just prevents this window from showing up in the Security assignment windows. Make sure that...

Which excel viewer does one use for Windows 98?
I am trying to find an excel viewer that will work with Windows 98; is there such a thing? Excel 2003 viewer requires a minimum of Windows 2000 This will work with win98 http://www.pcworld.com/downloads/file_download.asp?fid=5257&fileidx=1 -- Regards, Peo Sjoblom (No private emails please) "Puzzled" <Puzzled@discussions.microsoft.com> wrote in message news:4D7D72A0-FA8F-4FF3-A2D0-31C5D8B6B4FA@microsoft.com... >I am trying to find an excel viewer that will work with Windows 98; is >there > such a thing? > > Excel 2003 viewer requires a minimum ...

Cannot open the Insert object (Pdf file) form Excel 2000(9.0.8968 SP-3)
Dear All, I am no idea why I cannot open the embedded object (Pdf file) inside Excel file which using Windows ME. Once clicked the object icons, then it shows the error message likes " the embedded object cannot be opened by the source application" I used the Adobe reader 6.01 as the source application. Actually, I searched the related forum from the Internet. However, I cannot solve the problem. Anyone helps? Thanks tlee Hi, I can't test 2000 in ME, but it works fine in 2003 under XP. -- If this helps, please click the Yes button. Cheers, Shane Devenshire &q...

Form class module for non-existent form
Hi, After copying a form with a class module, something went wrong. I now have a class module for the new form, but the form no longer exists. I am unable to remove the in-limbo class module. I want to use that name for my form, which is not possible as long as that class module is in the way. How do I get rid of the in-limbo class module? I've tried repairing tha DB as well as "msaccess /decompile" but it hasn't helped. Anything else? Thanks, Kjell Kjell, A class module is not part of a form, but a separate module. It sounds like your 'in-limbo' module is...

SQL 2005
Hi, I am trying to import an excel file to a SQL 2005 table from client Management Studio and am receiving following error (it works fine when done directly from the server) Error 0xc00470fe: Data Flow Task: The product level is insufficient for component. I went through couple of blogs where they suggested to upgrade to SP3. My server is running SP3 but the version of my client Management Studio is 9.00.1399.00. I also do not see SSIS when I go to Management Studio -> Help -> About. Could anyone let me know how can i resolve this issue. Thank you. ...

Setting the Windows Cursor during Form Processing
hiya gurus I would like to force the mouse cursor to immediately become an hourglass when some long processing/quering commences on a form. it appears that it takes some time for Access to show the hourglass and usually only after the user clicks the form a couple of times because there appears to be nothing happening... Is there an easy way to do this from within Access.. I have done it in VB6 using Me.MousePointer = vbHourglass but this does nto work in Access.. any suggestions? cheers Jeff mmmmm Screen.MousePointer = 11 guess this does it? "jeff" <jeff@work...

opening csv file in regular excel format
i am using office 2003. i used to download csv files and open in regular excel formats...due to some problem i reinstalled windows xp and office 2003...now my csv files open with all values separated by commas and not as before... sould anyone highlight how to download csv files automatically in excel formats withouts commas? suresh babu,chennai,india -- sureshbabussb If the data has commas between each field and you want each field in a separate column, you'll have to make sure that your windows list separator is a comma. (Many places, this list separator is a semicolon.) windows...

Position 2nd Form according to 1st Form
I have 2 Forms. When the 1st Form is openned and want I open the 2nd Form, I want it to position itself about 15cm form the Left and 20cm from the top of the 1st Form. I am using Access 2003, Thanks. "AY" <AY@discussions.microsoft.com> wrote in message news:CFA3A4B5-36D9-4A20-AB57-601290155335@microsoft.com... >I have 2 Forms. When the 1st Form is openned and want I open the 2nd Form, >I > want it to position itself about 15cm form the Left and 20cm from the top > of > the 1st Form. I am using Access 2003, Thanks. You should be able to use Nicole Calinoiu...

Excel 97 #5
I need a 2004 Calendar for Excel 97...do you know where I can find one? I'm not sure what you're seeking. Orlando has a free download. http://cpap.com.br/orlando/#Calendar John Walkenbach has a free download : Appointment Calendar Maker, designed to produce calendar/appointment pages that are printed and inserted into a binder. http://j-walk.com/ss/excel/files/apptcal.htm Chip Pearson has a free download. http://www.cpearson.com/excel/download.htm A Google search should provide plenty of hits. http://www.google.com/groups?as_q=calendar&safe=off&ie=UTF-8&oe=UTF-8...

TOURNAMENT FORMS
Need tournament draw sheet single elimination template. You may find some old NCAA basketball tournament forms out on the web. Try http://google.com HHSTENNIS wrote: > > Need tournament draw sheet single elimination template. -- Dave Peterson ec35720@msn.com ...

EXCEL CERTIFICATIION
Is it possible to obtain certification from Microsoft to demonstrate my level of proficiency in Microsoft Office applications? See: http://www.microsoft.com/learning/mcp/officespecialist/req uirements.asp HTH Jason Atlanta, GA >-----Original Message----- >Is it possible to obtain certification from Microsoft to demonstrate my level >of proficiency in Microsoft Office applications? >. > ...

Run Macro only if certain form is open
I have programed a maco to open one of various forms depending on criteria on an open form. Is there a way to run a "follow up Macro" based on which form opens? In other words can I run a macro based on wheather a certain form is active? -- Thanks, Chuck Take a look at the RunMacro Method of the DoCmd object. You can have it as part of the OnLoad of the form in question. Chuck wrote: >I have programed a maco to open one of various forms depending on criteria on >an open form. Is there a way to run a "follow up Macro" based on which form >opens? In other w...

Modal form opens on startup
Evenin' - I hope this doesn't come across as stupid, but I'm almost completely unfamiliar with Access. A client of mine has an Access 2000 database containing some business information, and he'd like to have me import it into Quickbooks. The problem I have is that I cannot get to the information to export it from Access. When the file is opened, I get a (I presume) modal form, configured as a 'splash screen' type of thing. Has my client's logo, and the name of the fellow who wrote the Access app. Click that, and it closes, then opens another form for...

Forms and Input Data
I created a report form on Sheet 1 and a set of input data on subsequen Sheets 2, 3, ... link to the report. The report is to show informatio on either of the data I select. Are there simple steps for me to pick either set of data I want t display on the report? I've thought of a pull-down menu so that if select "1", the report will show data set "1", and so on. Yet I don' know how to do it. I tried the "replace" command by highlighting al the cell in the Report sheet then type "2" in place of "1" to replac the data set then hitting...

can not open excel file, too many different cell formats
can not open a specific excel file, too many different cell formats message appears on my screen. the file contians about 85 work sheets Some info: XL: Error Message: Too Many Different Cell Formats http://support.microsoft.com/default.aspx?scid=213904 A few people have posted that they could open the file in OpenOffice, then remove some of the formatting, save it and then excel would open that file ok. http://www.openoffice.org, a 60-65 meg download or a CD Abdur wrote: > > can not open a specific excel file, too many different cell formats message > appears on my screen. the ...