Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Add help messages to Excel applications with Data Validation
- You don't need to learn programming to provide help messages for your users. Excel's Data Validation feature makes it easy to add a help message to any cell in your worksheet.For example, suppose you create an application that calculates the amount of money your company must invest in order to...
- Tags: Microsoft Office, Excel
- Blog posts 2007-07-10
- How to add a dropdown list to an Excel cell
- Things To KnowIf you're using this tip, there are a few things to be aware of.You don't need to setup the list of options on a worksheet, you can just type the items into the Source box on the Data Validation dialog. ie Enter Yes,No,Don't Know to get these options.If...
- Tags: Microsoft Excel, gbentley@..., worksheet, Data Validation
- Discussion threads 2007-06-26
- SmartCodeComponent2D Barcode (exe)
- SmartCodeComponent2D lets you add professional quality 2D barcodes to documents like those from Word and Excel. It exposes a full range of barcode properties and allows precise control over the barcode dimensions. Data validation is carried out over inputs to ensure the generated barcode meet industry specifications. Supported symbologies include...
- Tags: Industry, Data Validation, Microsoft Excel, Microsoft Word, Strategy, Word Processors, Microsoft Office, Office Suites, Software, Management
- Software downloads 2007-04-18
- SmartCodeComponent (exe)
- SmartCodeComponent allows you to easily add professional quality barcodes to documents like those from Word and Excel. SmartCodeComponent will work flawlessly with any Windows application that supports OLE Object Linking and Embedding server. This includes most Microsoft Office products, WordPad and third-party software. It exposes a full range of barcode...
- Tags: Industry, SmartCodeComponent, Data Validation, Microsoft Excel, Microsoft Word, Microsoft Office, Strategy, Office Suites, Software, Management
- Software downloads 2006-10-11
- TechnoRiver Free Barcode Software Component (exe)
- Free Barcode Software Component allows you to easily add Code39, I2OF5, and ITF14 barcodes to Windows documents like Word, WordPad or Excel. It exposes a full range of barcode properties and allows precise control over barcode dimensions. The barcodes are generated as Windows Metafiles and allow accurate, high-resolution printing to...
- Tags: Industry, Barcode, Free Barcode Software Component, Data Validation, Component, Microsoft Excel, Microsoft Office, Strategy, Office Suites, Software, Management
- Software downloads 2006-10-11
- Data validation with JavaScript and regular expressions
- Discover how regular expressions offer a simple and elegant way to manipulate text within JavaScript. Tony Patton also explores how JavaScript's regular expression simplifies data validation. Data validation is an essential aspect of any Web application that accepts data from the user. After all, you must ensure the...
- Tags: JavaScript, Data Validation, Tony Patton, Scripting languages, regular expression, caret, Web Development Zone Newsletter, Parameter, Expression, String, RegExp, Escape Character, Software/Web Development, Web Development
- Technical articles 2006-09-18
- Search for invalid data in your Excel file
- Less elegant but very quick way to validate dataGood tip! It may be "too much work" for some situations. For a "quick and dirty" way to check data validity, one can turn on the AutoFilter (Data|Filter|AutoFilter). Clicking the "down arrow" at the top of each column will...
- Tags: validation, excel, data validation, AutoFilter, CMB from Omaha, hardware, Microsoft Excel
- Discussion threads 2006-05-10
- Excel
- Excel. In Edit, Go To Special dialog box, «All» and «Same» for Conditional formats and Data validation, both are selecting the whole data and not only the applied ones nor the ones as the currently selected cell. Whether I click the specific cell and check the «Same» box or not!...
- Tags: Microsoft Excel, cell, Conditional, zimonar@..., windows, Data Validation
- Q&A 2006-02-12
- Excel.
- In Edit, Go To Special dialog box, «All» and «Same» for Conditional formats and Data validation, both are selecting the whole data, not only the applied ones nor as the currently selected cell, if I click the specific cell or not! That’s because I should select all data to use...
- Tags: cell, Conditional, Data Validation, zimonar@..., windows, Microsoft Excel
- Q&A 2006-02-10
- Excel 97 - Copying controls to multiple locations
- I am working on a new form in Excel 97. I am including a drop down box that has 4 items. I would like to have the control in approx. 180 rows. I would like to be able to copy the control to all 180 rows at the same time....
- Tags: Microsoft Excel, Microsoft Office, Data Validation
- Discussion threads 2005-12-30
- access data validation conundrum
- i am trying construct a field data validation in an access 2000 form where it validates that a typed in part number is a valid part number.. i have the valid part numbers in a seperate table but have not found the correct syntax yet to have what is typed...
- Tags: Microsoft Office, Databases, part number
- Q&A 2005-12-19
- Automate data validation in VB6 with CausesValidation and Validate
- Don't let invalid user data problems sneak up on you—prevent them by developing programs that take into account data validation. Find out how you can automate the data validation process in VB6 using the CausesValidation property and the Validate event procedure. Data validation is an important part of many...
- Tags: Microsoft Visual Basic 6.0, Data Validation, Peter Aitken, CausesValidation, event procedure, TextBox, Visual Basic Tips Newsletter, TechRepublic Inc., Corporate Communications, Microsoft Development Tools, Programming Languages, Marketing, Development Tools, Software Development, Software/Web Development
- Technical articles 2005-10-20
- Avoid these six common development mistakes
- Avoid these six common development mistakesarticle rootsome very good pointsI think the best being version control.One case in point was my last place of employment, where I was first stationed at a PC that my manager knew was not on the backup power system for the building. Although I...
- Tags: developer
- Discussion threads 2005-09-21
- Excel combo box
- I need urgent help in excel using vba. I was not satisfied with the data validation so i made my own. I made a combbox that is visible in a specific column only.Unfortunately, the user can double click the cell and type in values that are not in the combobox....
- Tags: Activate ElseIf KeyCode, ActiveCell.Offset, ActiveCell.Value, admin@..., cell, combo box, comboBox, ComboBox1.Visible, data validation, excel, Microsoft Excel, programming
- Discussion threads 2005-09-08
- Add data validation to an Access form
- All is not lost if you didn't set data validation for a field during table design. See how you can add data validation to an Access form in four simple steps. Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel,...
- Tags: Microsoft Access, Microsoft Office, Mary Ann Richardson, Gender field, Microsoft Office Suite Access Tips Newsletter, TechRepublic Inc., Field, Data Validation, Databases, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2005-03-22
- Client-side data validation with XML
- One of my favorite parts of Web applications development is user interface design. My primary concern is with the flow of a page as opposed to how pretty it is. There is nothing more frustrating than having clients make their selections, click a button, and then wait for an entire...
- Tags: Edmond Woychowsky, XML-Data Islands, XML, data validation
- Technical articles 2004-03-01
- Ensure accurate data entry in Excel by using Data Validation to create drop-down lists
- You don't have to know how to program in Visual Basic to create drop-down lists and validate entries in an Excel spreadsheet. The Data Validation feature makes it easy to eliminate data entry errors.You could write a book about all the ways you can use Excel’s Data Validation feature. Like...
- Tags: PRODUCTIVITY, Microsoft Excel, Jeff Davis, Data Validation, data entry, cell, validation rule
- Technical articles 2000-04-27
Additional Resources
- Implementing Validation Rules Using Aspects
- This paper provides an overview of AOP-based data validation implementation in a sample loan processing application. The paper will look at validation rules for data fields with different validation requirements, which is common in most real-world applications. Annotations-based aspects using AspectJ are used to dynamically weave validation rules into existing...
- Tags: Validation Rule
- White papers 2005-11-08
- Prob in creating dropdown in excel
- while creating drop down in a workbook,when i tried to link it with another workbook via data->validation,it shows :"u may not use references to other worksheets or workbooks for data validation rules."I m using Office 2003.The answer is right there. You may not use references to other worksheets of work...
- Tags: Microsoft Office
- Q&A 2005-02-27
- Excel Data Validation
- I have been trying to set up Excel cell data validation with drop down lists from VBA Behind an Access application. I can do it with reference to a simple named or otherwise range defining a list, but not with a validation formula containing functions like OFFSET.I have also tried...
- Tags: Microsoft Office, David.Jackson@..., Microsoft Excel
- Discussion threads 2007-04-23
- << Previous
- page 1 of 1
- Next >>
