Pick value off sheet list for VBA code determination
Apologies for the cross post.
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 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.
|