Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up list of values based on single value from pick list | Excel Discussion (Misc queries) | |||
time sheet determination of what day and time rate | Excel Worksheet Functions | |||
look across row - pick highest value - take aplha code of column | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Pick List | Excel Discussion (Misc queries) |