Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Is this a feature new to Excel 2002?

Hi Tod -

It's not new - it's a form of data validation. You can restrict the values
which can be assigned to a particular cell using the Data Validation dialog.
Click on the Validation menu item in the Data menu. Here you can specify the
validation criteria - which type of value may be entered, min and max value
allowed, etc. If you select "List" from the Allow dropdown, you can then
specify the range of values which may be accepted, by entering the Source.
This is what turns your cell into a dropdown list.

Using the other tabs in the Data Validation dialog, you also have the option
to show an input message which appears when the user selects the cell, and
an error alert message which appears if the user enters an invalid value.

Hope that helps.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 : Unable to open files in MS Outlook 2002 Mr. Low Excel Discussion (Misc queries) 1 June 29th 07 02:12 PM
Was trendline available in Excel 2002 as a charting feature? teacher7 Charts and Charting in Excel 1 April 29th 06 11:48 AM
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl scampbell Excel Worksheet Functions 0 February 22nd 06 06:31 PM
Can you print labels using Excel 2002 in a Word 2002 mail merge? Individual_ Excel Discussion (Misc queries) 3 December 17th 04 08:39 PM
Excel 2002 files attached to Outlook 2002 EMails change size AJStadlin Excel Programming 1 October 15th 03 12:12 AM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"