Help...Using dropdown list

Tech-Archive recommends: Fix windows errors by optimizing your registry


Greetings,
I need to select an item from a dropdown list but display a different
name/number.
For example:
My dropdown list contains the following items:
Project in town
Project out of town
Project on the road
Projeect anywhere

I want to select the dropdown list and see the items listed above but
when I select an item, I want just a number to showup in the cell.

exm1: If I selected "Project in town" from dropdown, then a "1" would
be displayed in the cell.

exm2: If I selected "Project out of town" from dropdown, then a "2"
would be displayed in the cell.

I can make a list and set the dropdown to display that list by using
Data..Validation..allow:list...then select data range.

Thanks!


--
modicon2
------------------------------------------------------------------------
modicon2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4158
View this thread: http://www.excelforum.com/showthread.php?threadid=573943

.

Relevant Pages

  • Re: help collecting data.
    ... Dim GetC As String ... the code in the cell that I want the order numbers(info from column C ... "Otto Moehrbach" wrote: ... display them both, seperated by a comma ...
    (microsoft.public.excel.misc)
  • RE: Create a "cell button" to hide selected cells.
    ... What I'd like to do, however, is to select a range of columns to display so I ... Dim intPickMonth As Integer ... Create a ComboBox on Cell A1 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Visio 2007 visEquivTitle
    ... then the display is probably just turned off. ... Microsoft Certified Technology Specialist - Visio 2007 Applicaiton Development ... There is a function called 'tooltip' that works with a standard drawing. ... You can add the User.visEquivTitle cell to your shape and provide a string ...
    (microsoft.public.visio.general)
  • Re: Displaying formulae changes formatting
    ... "macropod" wrote: ... result for a given cell. ... With the macro I posted, you can display both the formula and it's result, ... Set CommentRange = Range ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Email Booster from Excel
    ... You can use Display instead of Send and then attach the file you want. ... Dim cell As Range ... Set OutApp = CreateObject ... 1.Instead of yes/no in criteria I wanted have it compared with date if the date and time matches to todays date and time then "yes" else no. ...
    (microsoft.public.excel.programming)