View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill (Unique as my name) Bill (Unique as my name) is offline
external usenet poster
 
Posts: 10
Default Pick value off sheet list for VBA code determination

Here is a sample of VBA code used to place a value in a cell base on
the value entered in the cell previous

If LCase(.Value) = "capital" OR _
LCase(.Value) = "grounds" OR _

(etc., for many lines)

..Offset(0, 1).Value = "MP"

The code works fine. Now I want the code to refer to a list on a
sheet to determine the value of a cell, i.e., if the value in a cell
equals an item from the sheet list, then a value is assigned to
another cell.

Is this possible?

Thank you in advance.