Re: What exactly is the purpose of a data form?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Using the Data>Form feature can make it easier to enter data into a table in Excel, or find an existing record.

It's a nice feature for users who don't have the time or programming skills to create their own UserForms.

You could also try John Walkenbach's Enhanced Data Form. It's a free
add-in that allows combo boxes, and unlimited fields.

        http://j-walk.com/ss/dataform/index.htm


Carter Devereaux wrote:
I'm studying Excel and just completed learning about data forms. Out of curiousity, what might be some types of applications/examples for using this feature? 


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

Relevant Pages

  • Re: Named Range in 2007
    ... you have to 'opt in' to the ... Ctrl-V and uses Excel to maintain a grocery shopping list; ... If Microsoft is now aiming Office at the 'average' ... looking to the help system or a newsgroup to find a feature you are ...
    (microsoft.public.excel.programming)
  • Re: Named Range in 2007
    ... you have to 'opt in' to the ... Ctrl-V and uses Excel to maintain a grocery shopping list; ... If Microsoft is now aiming Office at the 'average' ... looking to the help system or a newsgroup to find a feature you are ...
    (microsoft.public.excel.programming)
  • Re: Text to Speech in Word 2003 - how to configure?
    ... The Text to Speech functions within MS Office (rather than ... those in Windows) are Excel features (i.e. created by the ... so from MS's view the feature doesn't 'exist' in Word ...
    (microsoft.public.office.misc)
  • Re: Your favorite Excel Add-ins
    ... Utilities I use frequently in Excel: ... Jan Karel Pieterse's AutoSafe - Better than the built-in autosave ... feature, it doesn't overwrite the file, but saves a copy in a designated ... that's become disarrayed by frequent editing. ...
    (microsoft.public.excel.programming)
  • Re: Get rid of the Paste Formatting boxes
    ... I think you're more of a power whiner than a power user. ... In both Excel and Word recent versions have these little Paste Option square graphics that appear when you paste text. ... Make sure there is _always_ a "Turn this feature off" choice on the dropdown. ... I am quite comfortable reformatting my text manually - it is possible Microsoft has data from some of their less experienced users that they can't, ...
    (microsoft.public.word.docmanagement)